display a field in certain characters

H

hngo

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
 
D

Dirk Goldgar

hngo said:
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
Click to expand...

Set the field's Format property to

000
 
H

hngo

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"
 
Top