Empty Space on a Report

[Guest_imported]

Hi All,

1st time poster...

I bet this is a simple one but I can't figure it out.

I have created a report which prints as a Contacts' Reservation Confirmation Letter.

I have FirstName, LastName, Address, City, State Zip etc
at the top left of the letter/report to fit in a windowed envelope. My challenge is the varying length in peoples 1st and last names, addresses etc. So if the guys name is Bob Smith its printing like this 'Bob Smith' If i close up the fields on the report so that it prints 'Bob Smith' when it comes across someone called 'Bartholomew Jenkins-Smith' it cuts off most of his name. How do I get it to simply put one space between the fields regardless of the data length?

Thanks in advance for any help

Kind Regards -Lee

 

[sko]

Create one unbound text box for the full name.
Control Source: =Trim([FName] & " " & [LName])

Do the same for each address line.
Control Source: =Trim([Address1])
Control Source: =Trim([Address2])
Control Source: =Trim([city] & " " & [state] & " " & [zip])

This example allows a four-line address. Set the Can Grow, Can Shrink properties to yes on all the controls in case the extra line isn't needed.