Newbie Help

  • Thread starter Thread starter MadCrazyNewbie
  • Start date Start date
M

MadCrazyNewbie

Hey Group,

I`ve created a table, and one of my feilds is Telephone Number, I have my
feild setup as a long interger. As im in the UK all telephone numbers start
0. My problem is when i type in my number as for example 01234 567890, it
misses the 0 of the from and just puts 1234 567890. How do I get it so i can
have the 0 in front?

Ta
MCN
 
You need to change the field type to text.
This is standard practice with phone number fields, after all you will never
need to perform mathematical operations on them, which is what numeric
fields are for!

HTH,
Nikos
 
I theory it could be done with a custom format on a nymeric field, but that
qould assume a constant length or extra leading zeros on shorter numbers.
 
Back
Top