View Single Post
  #8  
Old June 4th, 2010, 06:56 AM posted to microsoft.public.access.gettingstarted
Ted Collins
external usenet poster
 
Posts: 1
Default Access Labels Maker Doesn't Work

Each is a field i.e. Home Phone, Work Phone, and Cell Phone in the Database
table.
At some point I think I selescted the use of the telephone number input mask
for data entry and everything appears with (@@@) @@@-@@@@ as the apparent
"format" in the table, queries, and reports other than in a label. I looked
at these fields in TableDesign ViewProperties and note that while the input
mask was shown for each, the Format property box was blank. So I typed in the
above desired format you gave me with the hope that that would finally be it.
No help phone numbers on the labels still appear as 1234567890.

"John Spencer" wrote:

Can you post the phone control's source?
Is it just a field? OR is it something like
="Home Phone" & [Home Phone]

I suspect that you have a display format that shows the phone number fields
with the formatting you see (very possibly the format is set at the table
field level). The actual value being stored is 1234567890.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

ted collins wrote:
The telephone numbers appear in the format I prefer "(000) 000-0000"
everywhere (tables, queries, reports) except when I select them to appear on
a standard Avery label using the Access Label Wizard. I want up to three
telephone numbers to appear on one line on the label i.e. the fields a
Home Phone, Work Phone, and Cell Phone. If the phone numbers are already
formatted the way I want them and appear correctly elsewhere why does
selecting them for use in a labels report cause this problem? They appear as:
1234567890.

.