Help with Labels and missing spaces

[Jamey Fountain]

Hi,

I'm printing a mailing list and I have my report compiled and set to
print. I've come across a problem though. All the spaces between fields are
missing. Names are run together and the city and state are one word, New
YorkNY. Not real legible. Does anyone have any hints on the coding I should
use to add spaces and commas to this?

An example line would be this =Trim([CITY]) & ([STATE]) comes out as
New YorkNY I need it to come out as New York(comma and 2 spaces) NY and I
also need to add spaces between names, first and last.

Thanks for any help anyone can offer.
--
Jamey Fountain
Systems Administrator
Gary, Thomasson, Hall & Marks
Professional Corporation
Attorneys at Law
jfou...@gthm.com
361-884-1961

[Veronem]

try this

=Trim([CITY]) & " " & ([STATE])

Hope this helps,
Mary

[Jo7hn]

Jamey
I think something like = trim$([city]) & ", " & ([state]) might do the
trick
HTH

jo7hn

"Jamey Fountain" <jfou...@gthm.com> wrote in message
news:Ksl76.189385$IP1.6...@news1.giganews.com...

[Stefan de Groot]

I think that =Trim([CITY]) & ",, " ([STATE]) should do the trick.
(that is "comma, comma,space")
stefan

[Douglas J. Steele]

Why 2 commas? All he wants is a single comma between the words:

=Trim([CITY] & ", " & [STATE])

(That's comma, space, space between the double quotes)

Note, too, that the entire string [CITY] & ", " & [STATE] is all contained
within the same pair of parentheses.

--

Doug Steele, Microsoft Access MVP
Beer, Wine and Database Programming. What could be better?
Visit "Doug Steele's Beer and Programming Emporium"
http://I.Am/DougSteele/

"Stefan de Groot" <stefan....@wanadoo.nl> wrote in message
news:3a7d5cff...@news.wanadoo.nl...