spacing

[Barb]

When printing lables or my address data page I cannot get
the spaces in phone numbers or postal codes to show.
Everything is together. Egostal code "L0LOLo" should be
LOL OLO, and phone numbers print(000)111-1111, should be
(000) 111-1111. I have tried everything to change
this? "Self taught, so not to swift" and Blonde. Can
you help me?

 

[Randy Wayne]

I am not sure this will answer your question, but let's
try.

If your label consists of data, it will almost always
print in the format it was saved, especially text data.

The easiest way (that I can think of) to fix the phone
number issue is to create separate fields for the area
code and the phone number. If this is possible than your
label fields could look like this:

[strAreaCode] & " " & [strPhoneNumber]

(note the space between the 2 double quotes creates the
space you want).

In essence, this says take the first data field
[strAreaCode] plus, here you use the ampersand (&). The
first double quote denotes the beginning of some text, in
this case just a space. The second quote denotes the end
of the text. Another ampersand and then your next text
field.

If you cannot (easily) separate the area code from the
rest of the phone number you could use a string parsing
statement, len(), but I will not "go there" unless you
need it.

I hope this helps. Let me know

 

[Ted]

If your data format is consistent, such as with phone
numbers, you can use an input mask to insert/specify
things like parenthesis, spaces, hyphens, uppercase,
etc. To do this, view the properties of a control, click
on the data tab, and look for "Input Mask".

Access has some built in masks (such as for phone no)
which you can get to by clicking just to the right of the
empty "Input Mask" field. Or, you can click inside the
empty field and press F1 for help on creating custom
masks.

Otherwise, your only choice may be to build the values
that you want using various text functions as mentioned
in the other reply. Hope this helps.

-Ted