keeping zeros

J

jkjmwilliams

I use last digits of SS# for StuId. However, access deletes my zeros if the
number starts with a zero. How do I prevent that from happening?
 
D

Douglas J. Steele

Make the field text, not numeric.

Realistically, since you're not going to be doing arithmetic with the value,
you don't need it to be a number.
 
C

CMoya

Or just change the Format property of the field to 0000. That way it will
always display leading zeroes.
 
J

jkjmwilliams

thanks! why didn't I think of that!


Douglas J. Steele said:
Make the field text, not numeric.

Realistically, since you're not going to be doing arithmetic with the value,
you don't need it to be a number.
Click to expand...
 
J

Jeff Boyce

Using 4 digits (characters) to serve as a unique studentID is risky ...
there are only 10,000 possible values to use, and there's no guarantee that
two individuals would not "share" the same last four characters of their
SSNs.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top