Trying to get leading zeros to show

[Pegasus_Angel]

I have been working in Access 2007 creating a database. For the most part I've been able to figure everything out but I have a field where I'm putting a three digit code. It has an input mask, that is set as a text file, and is "000". I thought that would force all three numbers to show even if there was a zero in front.

However, the leading zeros are being removed and I can't figure out how to make them stay so that I can see them. Does someone have simple explanation on how to fix it?

Just so you know I'm just learning access so the more detailed the answer the easier it will be for me to understand.

[ketbdnetbp]

Pegasus_Angel -

You may want to look at the field in the table's design view. If the data type is "Number", then, despite the input mask, when saved, the leading zeros will be removed. Back-up the DB first then, go to the table in design view. Change the datatype to text, change the format property to 000 and see if that resolves the issue.

All the best,

Jim

[Pegasus_Angel]

Pegasus_Angel -

You may want to look at the field in the table's design view. If the data type is "Number", then, despite the input mask, when saved, the leading zeros will be removed. Back-up the DB first then, go to the table in design view. Change the datatype to text, change the format property to 000 and see if that resolves the issue.

All the best,

Jim

Jim,

What I'm trying to fix is in a subforum and I'm not quite sure how to change it. I can tell it clearly is a 'numerical box' as the only format I can choose is number related but I'm not sure how to change it back to text.

Would I need to restart my whole form?

[ketbdnetbp]

Pegasus_Angel - I don't think you need to re-create the subform. Personally, I would backup the DB then, go to the subform in design view and delete that control from the subform. Next, I would go to the table in design view and make the changes I suggested earlier. Then, I would add that control back into the subform. Post back if you encounter any problems.


Jim