Format Issue

  • Thread starter Thread starter Susie
  • Start date Start date
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!
 
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.
 
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
 
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,
 
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...
 
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...
 
Back
Top