p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Hiding Autonumber Field (http://p2p.wrox.com/showthread.php?t=35100)

Brendan Bartley November 14th, 2005 08:16 AM

Hiding Autonumber Field
Hi All
I have a form which is Continuous on a database but the only problem is each time I open it it shows the Autonumber.Is there any way I can hide the autonumber field.

Brendan Bartley

mmcdonal November 14th, 2005 08:53 AM

Select the field, then select Properties, then on the General tab, set the Visible property ot No.


mmcdonal November 14th, 2005 08:54 AM

I meant, set the Visible property "to" No.


Brendan Bartley November 14th, 2005 10:35 AM

When I change the property visible to No it also hides previous call ID details.I need this information to be visible that is call id but is shows aotonumber which I need to hide

Brendan Bartley

SerranoG November 14th, 2005 11:34 AM

Are you saying that when you have a NEW record it shows something like "Call ID: (Autonumber)" and when you're on an existing record it shows something like "Call ID: 123456"? And that when you have a new record you want to hide it?

If that's the case, remember that autonumbers are nothing more than ID tags for records and should never been seen or manipulated by users at all. If you need a visible, meaningful Call ID, you should create a new non-autonumber field.

But to answer your question, on the form's ON CURRENT event, put:

Me.CallID.Visible = Not (Me.NewRecord)

Assuming your field is called CallID.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

All times are GMT -4. The time now is 02:18 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.