Newbie Help

[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

 

[Nikos Yannacopoulos]

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

 

[JustMe]

I may be wrong but I believe you also place the format in Quote marks

 

[Nikos Yannacopoulos]

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.