Dropping the zero

[samonwalkabout]

I have a primary key field. 5 digits ie 023/03 i am using an input mask of 00/000 but if the frist digit is a zero (as it will be until we generate over 99 records) then its not visable. The wizard wont run coz its a number field and the help file doesnt seem to contain the answers.

Thanks in advance

 

[neileg]

You can format this field to display the leading zero where you use it in a form or a report. But since it's a number, a leading zero has no meaning.

I would not use a field like this as a key. I tend to use an autonumber, and if I want to have another field with a fancy format, I add this on. Saves a lot of trouble.

 

[samonwalkabout]

I have it set up like this for many complex reasons.

You can format this field to display the leading zero where you use it in a form or a report.

Great Stuff.... Hows it done?

Thanks

 

[neileg]

The easiest way is to format in the table. Select your field in design view and in the format property type 000/00. Access will change this the 000\/00, and then show the field the way you want.

Any report or form will inheirit this format.

 

[samonwalkabout]

Thank you thats done the job a treat.