Leading Zeros

  • Thread starter Thread starter murfitUK
  • Start date Start date
M

murfitUK

Using Access 2000 on Windows XP Home.

I have created a field which will contain an item's code. The code is a
four digit number but can start with a zero.

In the table design, the field is set up as: Data Type = Number and Field
Size = Long Integer. But if I enter, eg, 0376 it comes up as 376.

How can I get it to display 0376 instead of 376?

I thought about changing it to a simple text field but I hit a problem when
sorting the records into numerical order.

Thanks for your help.
 
If you only care about it for display purposes, set the Format property to
0000
 
Using Access 2000 on Windows XP Home.

I have created a field which will contain an item's code. The code is a
four digit number but can start with a zero.

In the table design, the field is set up as: Data Type = Number and Field
Size = Long Integer. But if I enter, eg, 0376 it comes up as 376.

How can I get it to display 0376 instead of 376?

I thought about changing it to a simple text field but I hit a problem when
sorting the records into numerical order.

Thanks for your help.
Click to expand...

You can set the Format property of the number control to
0000
to display a number as 0376.

However, if the field is not going to be used in numeric calculations,
it should be a Text datatype field. All you need do, in the entry
form, is code the After Update event of the control to:

[ThisControl] = Format([ThisControl],"0000")

It will now be stored as a 4 character string, with leading zeros, and
sort as though it was a number, with no additional formatting needed
if used elsewhere.
 
Back
Top