number format

[AW]

I would like to format an ID number such as 01234 so that
the first zero is not lost. I also need to use "number"
rather than "text" formatting since I will perform
calculations on it. Is there a way to do this? In excel
I can use 00000. That doesn't seem to work in Access.

Thank you,
AW

 

[Wayne Morgan]

You can set the Format of the field to show the way you want. If the field
is a number field, it won't be stored that way, format is just a "visual"
item. You may need to go back and add the format to any controls on forms or
reports also that are already based on this field.

Open the table in design view and go to the field. In the dialog at the
bottom of the window, set the format option to 00000. You will find a
similar option in the Properties sheet of the controls on forms and reports.

 

[Larry]

You could store the ID numbers in your table as a number
(which will not have the leading 0), but display them on
forms or reports with a leading 0, when appropriate.

This way you would still be able to perform calculations
on them.

Larry

 

[AW]

The 00000 works. Thanks very much.

Amy

-----Original Message-----
You can set the Format of the field to show the way you want. If the field
is a number field, it won't be stored that way, format is just a "visual"
item. You may need to go back and add the format to any controls on forms or
reports also that are already based on this field.

Open the table in design view and go to the field. In the dialog at the
bottom of the window, set the format option to 00000. You will find a
similar option in the Properties sheet of the controls on forms and reports.

--
Wayne Morgan
Microsoft Access MVP





.