Problem Printing Envelopes in Access 2007

I am trying to print envelopes in Access 2007 using a report that has its page properties set to be the same size as  a #10 envelope.  This is working fine except for the fact that the fields are not lining up very well.  Because some names are much longer than others, and some addresses have an additional second line with a suite number for example, I can't seem to get everything formatted in such a way that it looks normal.


I would like to have the addresses look like this:


John Doe
123 Anywhere Street
Suite 100
Nashville, TN 12345



Instead it looks like:


John          Doe
123    Anywhere       Street
Suite   100
Nashville,       TN      12345


Any help would be appreciated.
apsonlineAsked:
Who is Participating?
 
shaydieConnect With a Mentor Commented:
Use unbound text boxes on your report and add multiple fields together into one text box something like this:
=[FirsName] & " " & [LastName]
=[AddressPart1] & " " & [AddressPart2]
=[City] & ", " & [State] & " " & [ZipCode]

set the control source something like that replacing the actual field names from your data.
0
 
Dale FyeCommented:
or you could merge the fields in the underlying query.

SELECT [FirstName] & " " & [LastName] as FullName,
             [AddressNumber] & " " & [StreetName] & " " & [StreetType] & chr$(10) & chr$(13) & [AddressPart2] as Address,
             [City] & ", " & [State] & "  " & [Zip] as CityStateZip
FROM yourTable

Using this method, you only need three controls (txtFullName, txtAddress, txtCityStateZip).  Set the CanGrow property of txtAddress to Yes.  Using chr$(10) & chr$(13) should provide for wrapping the second part of the address to a second line.
0
 
apsonlineAuthor Commented:
This worked great; thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.