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

*
 
Back
Top