display a field in certain characters

[Guest]

hi,

How do we set a field to display a 3 digits number. if user enter 2 digit
number it will display three digit code such as 70 become 070 or 1 become 001

many thanks in advance

 

[Joseph Meehan]

hi,

How do we set a field to display a 3 digits number. if user enter 2
digit number it will display three digit code such as 70 become 070
or 1 become 001

many thanks in advance

Display is a property of the table, report, etc. You need to set the
display property where you want it displayed as three digits.

Remember that Access saves "numbers" as numbers and numbers don't have a
specific number of digits. Text, which can include 0-9 does not change
from table to report etc, but you can't do calculations on text.

Give us a little more information about exactly what you want to do and
maybe we can offer more specific instructions.

 

[Dirk Goldgar]

hi,

How do we set a field to display a 3 digits number. if user enter 2
digit number it will display three digit code such as 70 become 070
or 1 become 001

Set the field's Format property to

000

 

[Guest]

Hi joshep,

I want to set an equipment number to become a three digits number and
dispaly in a three digits number. However the number only show as two digits
when you type in "70" I want it to show "070"

 

[Joseph Meehan]

Hi joshep,

I want to set an equipment number to become a three digits number and
dispaly in a three digits number. However the number only show as
two digits when you type in "70" I want it to show "070"

But where are you typing it in? Are you typing in a form, a query or a
table?