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!
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!
Starting With A 0 In A Number Field
0 commentaires:
Enregistrer un commentaire