In access when datatype is numbers how do i get spaces inbetween .

A

Asta

When in access in design view and i change the data type to Numbers and then
i go into DataSheet View how do i get spaces inbetween the numbers that i
have entered and how can i put 0's before each number without it deleting the
0?
 
B

Brendan Reynolds

You can't store either spaces or leading zeros in a numeric field. You can,
however, *display* the number with spaces and leading zeros, in queries,
forms and reports. For example ...

? format(123, "000 00")
001 23

Check out the format property and the Format function in the help file and
the online documentation for more details.
 
Top