A challenge with Access Reports and margins/columns.

[qwert231]

Here's the database I am working on. A form comes up with 3 buttons.
The first one transfers a comma delimited text file into a table.
The second button opens a report which runs a query that sorts and retrieves only certain information. It puts each line into a cell in a table, 3 across (3 columns) and then repeats on the next line. These cells are formated to fit on a sheet of labels. They need to remain just as I have set them in page setup!
The third button runs a delete query that clears the table.

During the actions of either the text transfer or the delete query the page setup settings are lost. The columns attribute reverts to 1 column and the margins revert to 1". I DO NOT WANT ACCESS TO DECIDE MY COLUMNS AND MARGINS. THIS 'FEATURE' IS NOT WANTED!!!

How can I prevent this from happening? Some have suggested PrtMip, but I have been unable to get this to work and nobody is able or wants to help me. PLEASE HELP ME!!!

 

[binky]

Have you tried going into your database options and setting up default page margins?
Under Tools -> Options -> General Tab, setup your necessary margins there.

Binky

 

[willyp]

Use your queries to build a table of results. Format your report ( labels ) to use the table. When you repopulate the table use a delete query to empty it and then your original queries to populate it.

All the fields will always exist and the report will always keep its settings. This has always worked for me. If it doesn't work for you send me an email of the details.

bparker@par-sys.com

WillyP