View Single Post
  #6  
Old June 2nd, 2010, 04:26 AM posted to microsoft.public.access.gettingstarted
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Access Labels Maker Doesn't Work

If you look in the table, you have stored them unformatted. You can change
that with an update query (for safety, use a new column) using the format
function that John provided you.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley


"ted collins" wrote in message
...
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.
--
elderuser


"John Spencer" wrote:

How are they appearing NOW? 123 4567890? You can use the format function
to
format the value
Format([TelephoneNumber],"(@@@)@@@@-@@@@")
If the number is 1234567890 then the format specification would be the
following if you wanted to add the space.
"(@@@) @@@-@@@@")


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

ted collins wrote:
Thank you! Once I figured out how to get to the toolsreferences, I
found
"utility.mda" with "MISSING" in front of it and I unchecked the box and
the
labels appear almost perfect. Seems like there is always one more
thing. The
labels will include phone numbers and the numbers appear in the labels
but
without the normal formatting: i.e. (xxx) xxx-xxxx, the ( ) and - are
missing. What do i do to make them appear?

.