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.
Thanks
Brendan

Brendan Bartley

__________________
Brendan Bartley

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

mmcdonal

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

mmcdonal

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

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