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!

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

How can I auto-prefix my autonumber field?

Access Howto:

How can I auto-prefix my autonumber field?

by  jimmythegeek  Posted    (Edited  )
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
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top