Auto Formating

  • Thread starter Thread starter Karan
  • Start date Start date
K

Karan

Hi,

If i enter and number in a field, i want to show zero ( 0 ) in front of the
number?

for ex: if i enter Number: 1, it should automatically show as 001. (three
digits)

Please, help.

Karan
 
Karan said:
Hi,

If i enter and number in a field, i want to show zero ( 0 ) in front of the
number?

for ex: if i enter Number: 1, it should automatically show as 001. (three
digits)

Please, help.

Karan
Click to expand...
On a form, place a control with the control source as:

=Format$([number],"000")

where [number] is your number's field name.

Note that the name of the control must not be "number" or you will get an
error.

David
 
Karan, open the table in design view and set the format property for that
field as follows: 000. For a form, open the form in design view and set the
format property for the bound control to 000.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
Open the table in design view. Click the field you need to format. In the
Field Properties, Format Row, type 000.
0 Digit placeholder. Display a digit or 0
So, when you type 1 in the Field, it will display 001. When you enter 10, it
will display 010. And when you enter 100, it will diplay 100.
If you need two leeding zeroes before any number, just type "00"###, where
the number of the # is equal to the number of the digits you need to display
before the zeroes.
 
Back
Top