formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I want a column to be only 5 numbers long, some with a letter, with the
first being 0's, what do I do?
I.E.- I enter 101 and I want it to read 00101. Some of these will have a
letter at the end so it will have to be text.
I.E.- I enter 101A, it will read 00101A.
Any suggestions?? This is in a table I am developing.
 
try

left("00000",5-len([fieldname]) & [fieldname]

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 

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

Back
Top