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
|
|||
|
|||
How do I open my report in print preview mode in Access?
I am using Access 2007. I have my report opening in print preview mode when
I open it from the navigation bar. When I open it from the switchboard it opens in report view. How can I get it to open in print preview from the switchboard? |
#2
|
|||
|
|||
How do I open my report in print preview mode in Access?
On Wed, 7 Apr 2010 11:10:01 -0700, SwMC wrote:
I am using Access 2007. I have my report opening in print preview mode when I open it from the navigation bar. When I open it from the switchboard it opens in report view. How can I get it to open in print preview from the switchboard? Display the VBA code window for the Switchboard form. Find the Private Function HandleButtonClick(intBtn As Integer) function in the code. Drop down a bit further to the Select Case rst![Command] section of the function. Change the conCmdOpenReport so it looks like this: Case conCmdOpenReport DoCmd.OpenReport rst![Argument], acPreview Save the changes. Done. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|