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")
 
Top