Unique Identifier beginning with "00"

[dsaxena15]

Hey guys,



I'm designing a departmental database for a university and the Student id's begin with double zeroes (for eg- 005821248). But when I enter the digits, the zeroes disappear and I'm left with "5821248". I have to have the zeroes in there.

How could I do this? I would really appreciate some help. Thanks.

[June7]

Have to make the field a text datatype, otherwise use formatting to display value with the placeholder 00, however, this doesn't change the actual value in table.

Identifier data should always be text field, even if the identifier is composed entirely of digits (with or without punctuation like SSN and phone number).

[RuralGuy]

The Rule-of-Thumb is "unless you will be doing math with the number, make it a Text field."

[dsaxena15]

Alright! Got it! @RuralGuy @June7; Thanks guys, I really apprecaite it!

[RuralGuy]

Are you ready to use the Thread Tools at the top of the thread and mark this thread as Solved?

[dsaxena15]

Oh! I dint know I had the privilege to do that. Never looked in Thread tools. i thought only the admins could that. Anyways, thanks, I'll keep this in mind for the next time