A challenge for all. Report column and margin settings.

[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!!!

 

[CosmoKramer]

Did you try using the label wizard to create a report for you and run that report using your second button?

 

[qwert231]

Yea... The first time it work's, the next it doesn't. The report changes it's Page settings in between uses. I turned of the AutoName function and that seems to be helping, but I know you can set margins in macros for word, and would assume you can do it here as well, since I have seen VBA code for it.

 

[Guest_imported]

If you go to the Tools menu and select Options, under the General tab you can set the default margins that the database. These also apply to reports. If you have a standard that you are trying to use, or are able to establish one for all of you printed materials, you can set the margins and header/footers here, and not have to worry about it again. Hope that helps...