Starting With A 0 In A Number Field

[Reese]

I have a field to record the last 4 digits of a credit card number in regards to tracking payment information.

The field is currently formatted as a Number field. When I try to enter a set of 4 numbers that start with "0" (e.g. 0123), Access removes the 0 from the start automatically (so 0123 becomes 123).

That function makes perfect sense under normal circumstances, but in this case I want to be able to keep the 0 at the beginning because it is part of the 4 digit sequence.

Does anyone have any suggestion? Thanks!

 

[JHB]

Is it necessary to have at the table level?
Else you can use the format function to show it in queries, forms and reports.

 

[Reese]

Is it necessary to have at the table level?
Else you can use the format function to show it in queries, forms and reports.

I suppose not, but it seems the most direct option. The only places that the field is used is on certain forms. No queries or reports.

Are you suggesting that I use a property for the relevant textboxes within the forms to force the "0" to be visible? Which property would I use?

 

[JHB]

I just check it, put in 0000 in the format for the field - table level, it should work

 

[Reese]

Perfect! Thanks!

 

[JHB]

Good luck.