Formatting a Phone Code

  • Thread starter Syed Zeeshan Haider
  • 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,
 
S

Sean

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.
 
S

Syed Zeeshan Haider

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!
 
Top