number of zeros

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

Guest

Hi all. In my form, there is a unique number that we enter, it shows up as 9
for example, is there any way I can make this a 3 digit by default, so it
would be 009?

Thanks!
 
Are you asking how to require a three character entry? Or how to display a
one-digit number as a three character string?

Numbers are things that can be added/subtracted. A "code" is a string of
characters, which could all be digits.

Are you working with a text field or a numeric field?

Take a look at Input Mask for ways to constrain what gets entered. Take a
look at Format for ways to alter the displayed values.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks Jeff.

Jeff Boyce said:
Are you asking how to require a three character entry? Or how to display a
one-digit number as a three character string?

Numbers are things that can be added/subtracted. A "code" is a string of
characters, which could all be digits.

Are you working with a text field or a numeric field?

Take a look at Input Mask for ways to constrain what gets entered. Take a
look at Format for ways to alter the displayed values.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Back
Top