Link to home
Start Free TrialLog in
Avatar of apsonline
apsonline

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of shaydie
shaydie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dale Fye
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.
Avatar of apsonline
apsonline

ASKER

This worked great; thank you