storing 16 digit number

  • Thread starter Thread starter WB
  • Start date Start date
W

WB

any suggestions on how to create a field to store a 16 digit number (gift
Card number). I don't believe I can use a data type as a number since the
card number is so long. Your input is appreciated.

wb
 
Use text. Since it's unlikely you're going to do arithmetic on it, there's
no reason to store it as a number. If you're going to be putting in logic to
check that it's a proper card number, you're probably going to be adding
together particular digits and the such, and the Mid function is what you'll
need for that.
 
any suggestions on how to create a field to store a 16 digit number (gift
Card number). I don't believe I can use a data type as a number since the
card number is so long. Your input is appreciated.

wb
Click to expand...

You're correct. You'll never be doing math with this "number" anyway,
so a Number datatype is inappropriate anyway!

Simply use a Text field; if you wish, use an Input Mask of

0000000000000000

to force entry of exactly 16 numeric characters.

John W. Vinson[MVP]
 
Back
Top