Formatting a Phone Code

  • Thread starter Thread starter Syed Zeeshan Haider
  • Start date Start date
S

Syed Zeeshan Haider

Hello Experts,
I have Access 97 Pro on Win98SE.

I have some experience of working and programming in Excel and VBA for Excel
but I am just a beginner of Access.

I want to format a column of a table (in Design View) for displaying
telephone city codes in following format:

0433
04531

In other words, every integer must have *only* one 0 before it. What is the
formatting code for adding a zero before any integer?

Thank you,
 
You won't be able to put a 0 in front of a number, the field will have to
be a text field.
Then look at the Format function...
You may want to create a query to view the table, where you use the format
function for your PhoneNo field. If you did this then you can stay with
the number field.
 
You won't be able to put a 0 in front of a number, the field will have to
be a text field.
Click to expand...

Thanks for the response!
I have decided to stuck with text format.

Thanks again!
 
Back
Top