Solved How do I formatt an Address in a report.

[progrob]

I'm trying to print addresses using report.
The spacing between fields is off because names, addresses, and cities all have different lengths. Using layout view helps a little but still leaves too much space between fields on my report. If I reduce the field size in layout then longer first names or towns get cut off or overwritten by the nex

I'm hoping to have addresses print out looking like:

John Doe
123 Easy Street
Anytown, CA 99999

Jameson Hacker
789 Home Street
Realylargetownname, WA 99009

Instead of being aligned with the field sizes in layout view.

Any ideas?

 

[Gasman]

Concatenate the fields into one control?

 

[Gasman]

Hmm, I was thinking it would need vbCRLF or the Chr() equivalent between ALL fields?

 

[progrob]

Thanks, got it to work.

 

[Gasman]

Thanks, got it to work.

Well, please post your solution. It might help someone else in the future.
After all that is what this site is for?