
April 21st, 2005, 12:58 PM
|
|
Registered User
|
|
Join Date: Apr 2005
Posts: 9
Time spent in forums: 2 h 22 m 34 sec
Reputation Power: 0
|
|
Automating Page Layout for a report
Here's the background:
I have an Access database which contains addresses. I want to be able to print those addresses to mailing lables via a report. Now, I KNOW I can simply create a new report using the label wizard, and specify all the information about those labels at that time. However, the idea of creating a new report EVERYTIME I decide I want to change what size label I use bothers me.
So here's the quetion:
Given an unbound form that will take input describing the page layout (such as margins, number of columns, etc), what code do I need to write to update these values to the report's page layout, and where do I put it? And I would greatly appreciate an answer that does not involve me purchasing a book or some other software to do this. I know it can be done with what I've got, I just don't know how.
Oh, by the way, it's an Access 2000 database.
|