INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

Access Howto:

How can I auto-prefix my autonumber field? by jimmythegeek
Posted: 3 Apr 02 (Edited 27 Sep 07)

Let's say you always start your invoice numbers with "INV" or "ORD", and you would like your autonumber field to do this automatically. No problem. In the Format propery of your autonumber field, you simply put

>"INV"  OR
>"ORD"

Now on all your lists, combos, reports, etc, the field will show up as INV34452 instead of 34452. This will work for any field, so you could do the same thing on a Text primary key value. So the user may enter 02577, but if you have >"INV" in the format property of that field, it will show up as INV02577.

==========================

Jim Lunde
jimlunde@gmail.com

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Resources

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