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)
 
Back
Top