Labels Have no spaces

F

Fons Ponsioen

If you concatenated the fields to obtain the results you
listed it may have been caused in the undelying query or
in the report.
When you concatenate fields will need to use this type of
format [firstname] & " " & [lastname], in this case
the " " adds a space between the first and last name.

Or: [City] & ", " & [State] & " " & [zipcode]
in this case the ", " adds a coma and space and the " "
adds a space.
Hope this helps
Fons
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top