put 0 in front of number field

D

dlb1228

i have a number field like the following:
125645
1236544
54623211
125487
i want the field to be 10 positions with zeros in front how do i make
this field like this?
0000125645
0001236544
0054623211
 
K

KARL DEWEY

A number field can not. A text field can or a text box displaying a number
field by formatting.
 
K

Klatuu

You can format it in the query:
AliasName: Format([MyField], "0000000000")

But, the data type will be text.
It is slower to execute than without the formatting.
It is better to put the formatting on the report or form.
The above technique is, however, good for exporting formatted data to Excel
 
Top