If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Set default print preview and Print settings for a Query or Report
How do I set a default print preview and Print settings for a individual
Query or Report. For instance, I have a specific query. When I click on print preview, I would like to have the print preview automatically show the query in "Landscape" 8.5 by 14 and be able to print it from there. I can do this through page setup, but I have to go through the proceedure each time I open the query. The print preview of the Query always opens in "Portrait" 8.5 by 11 and does not show all the fields. Please Help, jbeck2010 |
#2
|
|||
|
|||
Open the report in design view.
From the File menu, choose Page Setup. Choose the orientation and paper size there. Save the report. Note that if your default printer does not support this size paper, you will also need to specify a "Particular Printer" in that dialog, or the settings may not stick. If they still do not stick, then you have stuck this bug with Name Autocorrect: http://support.microsoft.com/?id=231634 -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "jbeck2010" wrote in message ... How do I set a default print preview and Print settings for a individual Query or Report. For instance, I have a specific query. When I click on print preview, I would like to have the print preview automatically show the query in "Landscape" 8.5 by 14 and be able to print it from there. I can do this through page setup, but I have to go through the proceedure each time I open the query. The print preview of the Query always opens in "Portrait" 8.5 by 11 and does not show all the fields. Please Help, jbeck2010 |
#3
|
|||
|
|||
Allen,
Thank you for your help. Your proceedure works great on a report. I was wondering if there was a similar proceedure that would work on a Query. When I apply the same technique to a Query, save and close the Query, and reopen it, it reverts to portrait 8.5 by 11. Do you have any suggestions? Thanks again, jbeck2010 "Allen Browne" wrote: Open the report in design view. From the File menu, choose Page Setup. Choose the orientation and paper size there. Save the report. Note that if your default printer does not support this size paper, you will also need to specify a "Particular Printer" in that dialog, or the settings may not stick. If they still do not stick, then you have stuck this bug with Name Autocorrect: http://support.microsoft.com/?id=231634 -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "jbeck2010" wrote in message ... How do I set a default print preview and Print settings for a individual Query or Report. For instance, I have a specific query. When I click on print preview, I would like to have the print preview automatically show the query in "Landscape" 8.5 by 14 and be able to print it from there. I can do this through page setup, but I have to go through the proceedure each time I open the query. The print preview of the Query always opens in "Portrait" 8.5 by 11 and does not show all the fields. Please Help, jbeck2010 |
#4
|
|||
|
|||
No. Unlike reports, queries just display data. They are not designed to have
the power of reports, so they just use the default printer's paper size and orientation. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "jbeck2010" wrote in message ... Allen, Thank you for your help. Your proceedure works great on a report. I was wondering if there was a similar proceedure that would work on a Query. When I apply the same technique to a Query, save and close the Query, and reopen it, it reverts to portrait 8.5 by 11. Do you have any suggestions? Thanks again, jbeck2010 "Allen Browne" wrote: Open the report in design view. From the File menu, choose Page Setup. Choose the orientation and paper size there. Save the report. Note that if your default printer does not support this size paper, you will also need to specify a "Particular Printer" in that dialog, or the settings may not stick. If they still do not stick, then you have stuck this bug with Name Autocorrect: http://support.microsoft.com/?id=231634 "jbeck2010" wrote in message ... How do I set a default print preview and Print settings for a individual Query or Report. For instance, I have a specific query. When I click on print preview, I would like to have the print preview automatically show the query in "Landscape" 8.5 by 14 and be able to print it from there. I can do this through page setup, but I have to go through the proceedure each time I open the query. The print preview of the Query always opens in "Portrait" 8.5 by 11 and does not show all the fields. Please Help, jbeck2010 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unable to print, page setup or preview | Jan Il | Outlook Express | 2 | January 23rd, 2005 09:10 PM |
Excel 2000 portrait print preview and printing | ChiragV | General Discussions | 0 | July 27th, 2004 06:02 PM |
Page prints differently than shown in Print Preview | Suzanne S. Barnhill | Page Layout | 0 | July 22nd, 2004 03:42 PM |
Bug: print preview in form datasheet with server filter on crashes access (ADP A2002 SP3) | Eric Cárdenas [MSFT] | Using Forms | 4 | June 24th, 2004 08:38 AM |
Print preview Zoom default | Norm Rasmussen | General Discussion | 6 | June 21st, 2004 11:19 AM |