Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keep "autonumber" from appearing on an entry form? 2

Status
Not open for further replies.

revheim

Technical User
Dec 23, 2000
2
US
I have used the autonumber feature to assign a sequential invoice number for a job order entry form. The problem is when the form opens in data entry mode the invoice number field displays "autonumber" until I begin entering information into the form, then the next sequential number appears. Everything works fine with the autonumber assigning the next invoice number, however, I don't want to see "autonumber" in the field on the form. Any help is appreciated.
 
Open a text box on your form, enter the following expression, using your autonumber field name for "ID":
Iif([id]="autonumber","",[id])
Of course, you don't put the autonumber field on your form.
 
Another approach I use a lot is simply making the field visible propery, false or NO
Then move it out of the way if you need space.
So everything functions as normal but it is not in the way.
you can also change its labe to say something like "Autonumber do not delete". So later if you are cleaing house it won't get deleted by mistake.

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top