Format autonumber

A

Amateur

I know that I can format an autonumber for example like this: "KAM-"0000 and
the value will be KAM 0001 .... end so on.
I would like that instead of KAM, a field of a table is shown.
For example (something like this):"customertable!ID-"0000
If yes, how can I do this?
Thanks
Klaus
 
A

Al Campagna

Amateur,
Keep the ID and the Autonumber as they are, but use a calculated, unbound, field to
"display" the "concatenated" value... in any form, query, or report.
= ID & "-" & YourAutoFieldName
If ID = 176, and AutoNum = 1826 then the above will display...
176-1826
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
VSTO C# add in Outlook.Appointment error 0
Re posting Please help (Macro for Special Sorting) 4
Macro for Special Sorting 4
Justification function versus wide spaces 0
Help on sumproduct function 8
Excel does not accept text format! 0
Convert string to military time string 14

Top