×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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?

2
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.

RE: Keep "autonumber" from appearing on an entry 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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close