Keep "autonumber" from appearing on an entry form?
Keep "autonumber" from appearing on an entry form?
(OP)
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.
RE: Keep "autonumber" from appearing on an entry form?
Iif([id]="autonumber","",[id])
Of course, you don't put the autonumber field on your form.
RE: Keep "autonumber" from appearing on an entry form?
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.