Print preview

[Chum]

This question deals with ACCESS 2002 and 2007.

When I want to print a table or query, I bring up the print preview and make adjustments such as margins. Can this be saved so that I don't have to go through changing margins every time I want to print a table or query?

 

[G37Sam]

There's a reason for that and that's because tables and queries are not meant to be printed, you should ONLY print reports.

 

[Libre]

This question deals with ACCESS 2002 and 2007.

When I want to print a table or query, I bring up the print preview and make adjustments such as margins. Can this be saved so that I don't have to go through changing margins every time I want to print a table or query?

Hi - I have a workaround.
By the way, the comment about not printing queries and ONLY printing reports is just foolish. Is ACCESS your tool or are you the tool of ACCESS? If you want to print a query, you can print a query.
The trick is to design a FORM which will open as a DATASHEET. The datasource for the FORM is the QUERY you want to print. The FORM will look almost exactly like the QUERY, except that it will remember the formatting. You can also do tricks with it, like having click events on the fields (for "drilling down" or making other forms open).
The code to open a form in datasheet mode is the following:

DoCmd.OpenForm "frmYourForm", acFormDS

So you create the query, then create the form using the query as the datasource for the form, and then open the form in datasheet mode and you can get a print preview, you can format it, and you can print it all day long even though it is not strictly a "report".

 

[G37Sam]

By the way, the comment about not printing queries and ONLY printing reports is just foolish. Is ACCESS your tool or are you the tool of ACCESS? If you want to print a query, you can print a query.

Sure, and if you want to use a fork to cut through your rare steak you can also do that but is that what it's meant for?

PS: not agreeing with my suggestion doesn't grant you the right to call it foolish

 

[Libre]

Or, you can just look at that rare steak instead of eating it, since all you have is a fork, and steaks weren't MEANT to be cut with a fork.
If I don't have the right to say that attitude is foolish, then let me just say, I disagree.