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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Force new line in control source of a report 1
Help using formulas and trickery PLEASE 1
Importing telephone numbers from excel 7
Table History for Newbie 15
New to queries 3
FORCING A ZERO AT BEGINNING OF A NUMBER 4
Addiing a Zero to a number which is already there 1
Adding values in two feilds based on condition 1

Back
Top