keeping zeros

[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?

 

[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.

 

[CMoya]

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

 

[jkjmwilliams]

thanks! why didn't I think of that!

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.

 

[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

 

[Linq Adams via AccessMonster.com]

As Jeff said, you shouldn't be using a 4 digit ID. We're used to entering the
last 4 digits of our SSN on various sites, but that's not an ID number; it's
simply being used to compare with the last 4 digits of the previously entered
ENTIRE 9 digit SSN.