View Single Post
  #4  
Old May 31st, 2010, 03:31 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default Access Labels Maker Doesn't Work

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?