Text box spacing

G

Guest

I have a report (form Letter) with spacing problems
I store the name and address information in the following manner Title,
first name, Middle Name, Address, City and State, zipcode
The problem is when I place the text boxes on the report they display
incorrectly
I would it to look like a standard adress label

Mr. Jack Jones
1234 Lane
Atlanta,Ga 30335

Instead of
Mr. Jack Jones
1234 Lane
Atlanta, Ga 30335

does this have to do with can grow or shrink...
 
D

Duane Hookom

You can use single text boxes for each line by concatenating the fields
like:
=[Title] & " " & [First Name] & " " & [Middle Name] + " " & [Last Name]

Make sure the name of the text box is not also the name of a field.
 

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