Report Layout (for letter address)

[GaryK]

Hi,

I have a report that produces letters for mailings. The report has a subreport which contains the company (sender) address and this is positioned in the top right of the report.

What I want to do is have the address lines left-aligned, but with the address block aligned right.
The sender address varies (ie, in some cases the longest line is maybe 20 characters, whereas in other cases it could be 50 characters). This is where I am struggling - the narrower addresses are not "tight" against the right of the page.

First example showing shorter company name which results in unwanted space to the right of the page.....

<--------------------------------- Page Width ----------------------------->

Company Name
Address Line 1
Address Line 2
City
Zip
​

Second example showing a longer company name which is positioned against the right of the page.....

<---------------------------- Same Page Width ---------------------------->

Another (wider) ABCDEFG Company Name
Address Line 1
Address Line 2
City
Zip
​

Is this possible with Access Reports (having the address left-aligned, yet always tight against the right side of the page)?

Thanks
Gary

 

[vbaInet]

This is easily done in Word. Access reports aren't built with this functionality. Use the query as your data source in Word.

Welcome to the forum by the way