Format Issue

S

Susie

I am working with tables from another source, and in that
table there are phone numbers and zip codes. I am not
able to make any formatting changes on the table. I want
to format the telephone numbers and zip codes on a report,
but have no "Formatting" options (the dropdown is blank)
in the properties in either the query or the report. Is
there a way to format these fields another way? Thank you
in advance for your help!
 
C

Cheryl Fischer

You can create formats for numbers in a query or in textboxes on a report
using the Format() function. A description of this function and how it can
format numbers, dates, etc., is available in VB Help. We could suggest
some examples for you to try; however, it is impossible to do so without
having some idea of what the data in the external tables looks like. If
you would post a small but representative sample of what your data in the
external tables looks like and how it should be displayed in the report,
perhaps we can help.
 
G

Guest

Hi Cheryl,

First of all, thank you so much for your help. The data
in the tables is simply a string of numbers. I would like
the telephone numbers to appear as (xxx) xxx-xxxx, and the
zip codes to read xxxxx-xxxx. If you could let me know
how I could use the Format () function in this case, that
would be great.

Thank you,

Susie
 
C

Cheryl Fischer

To get a formatted phone number, insert the following into the Field: row of
a query:

NewPhone: Format([Phone],"(000) 000-0000")

For a formatted zip code, use:

NewZip: Format([Zip], "00000-0000")

hth,
 
S

simederi

Susie said:
I am working with tables from another source, and in that
table there are phone numbers and zip codes. I am not
able to make any formatting changes on the table. I want
to format the telephone numbers and zip codes on a report,
but have no "Formatting" options (the dropdown is blank)
in the properties in either the query or the report. Is
there a way to format these fields another way? Thank you
in advance for your help!
Click to expand...
 
S

simederi

Susie said:
I am working with tables from another source, and in that
table there are phone numbers and zip codes. I am not
able to make any formatting changes on the table. I want
to format the telephone numbers and zip codes on a report,
but have no "Formatting" options (the dropdown is blank)
in the properties in either the query or the report. Is
there a way to format these fields another way? Thank you
in advance for your help!
Click to expand...
 
Top