 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Report layout
Hi, How do I get the report preview to show maximized and at 80% Thanks, J. Just go: docmd.OpenReport "name of report",acViewPreview docmd.Maxmimize DoCmd.RunCommand acCmdZoom75 I don't think there is a zoom80, but 75 should be close... Note that you can put the docmd.Maximize in the reports on-open event (all mine do that), the zoom command has to be executed *after* the report loads, and thus needs to follow the openreport command in code as above...  SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com I get Run-time error '2046': The command or action Zoom75%' isn't available now. > Just go: > [quoted text clipped - 7 lines] > mine do that), the zoom command has to be executed *after* the report loads, > and thus needs to follow the openreport command in code as above... >I get Run-time error '2046': > The command or action Zoom75%' isn't available now. do you have any prompts in your sql code (parameters), or perhaps some type of message box? the report's on open event code HAS TO FINISH. Actually, likely it means the report needs to have finished being rendered before you execute the DoCmd.RunCommand acCmdZoom75 Post your 2-3 lines of code you using to open the report. I suspect if you have any type of dialog prompts, or parameters, then you need to change your approach... SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com There's no prompts but there is a function called from the SQL that is the form's data. > >I get Run-time error '2046': > > The command or action Zoom75%' isn't available now. [quoted text clipped - 10 lines] > I suspect if you have any type of dialog prompts, or parameters, then you > need to change your approach... There's no prompts but there is a function called from the SQL that is the report's data. > > >I get Run-time error '2046': > > > The command or action Zoom75%' isn't available now. [quoted text clipped - 12 lines] > > I suspect if you have any type of dialog prompts, or parameters, then you > > need to change your approach... also how do I run down the left half of A4 page then resume at the top and go down the right? Thanks, > Just go: > [quoted text clipped - 7 lines] > mine do that), the zoom command has to be executed *after* the report loads, > and thus needs to follow the openreport command in code as above... > also how do I run down the left half of A4 page then resume at the top and > go down the right? > Thanks, Do you mean you want two columns of data? You have to "ensure" your layout is LESS then 1/2 the available space, and then in page setup, you see the options for specifying the number of rows for your data. SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.