Can i get access to auto fill add zero's? eg. 00422 for 442?

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

Guest

Hi, I'm using access 2003,

I have a registraion system that random generates a 5 digit number between 1
& 99999. the trouble is i need it to store in as 5 characters. 442 should be
00442, or 3 - 00003.

Is that possible to do? where and how??

Thanks
 
If it's a numeric field, all you need to do is set the format to 00000.

If it's a text field, you can do something like Right("00000" & MyField, 5)
 
You must log in or register to reply here.

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

validation rule for exactly 5 digits, including leading zeros 0
Leading zero's 2
Access 2003 SP3 dropping preceding zeros on formatted number field 1
Can I make an Auto Number start with zero 6
Help needed on zero filling the left and middle and concatenate 0
Add leading zeros fill space 3
Auto fill numbers starting with zero 3
How can I have field fill in automatically from one form to a 2nd 10

Back
Top