Mobile Phone Numbers in Axcess 2003

S

spearchukka

In my database any mobile phone numbers I enter show up without the leading 0
ie instead of 07xxxxxx I just get 7xxxxx. How can I rectify this
 
K

Klatuu

You are storing the mobile number as a number. It should be stored as text.
Numeric fields do not have leading zeros. It is possible to add leading
zeros using the format function:

=Format([MoblieNumber],"000\-000\-0000")
 

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

Access Tidy up phone numbers 0
Mobile Phone for Seniors. 1
Phone Clock 4
Buying a modern phone help needed. ;-) 14
Linking new phone to computer. 7
Word Create a Phone Book using MailMerge in word 2007 0
UK bar owner builds Faraday cage to prevent customers using mobile phones 5
Mobile phone AntiVirus 1

Top