Cosmetic problem with previewing Reports

Pozko

New member
Local time
Today, 15:56
Joined
Dec 3, 2002
Messages
7
Hi,
I'm fairly new to Access 2000 and have a small, cosmetic problem with previewing Reports. All I want to do is: When I preview a Report prior to printing I want the Report screen maximized. How do I set it to do so automatically?
Pozko
 
Do you have a button to preview your report? If so, enter this following the code in your button that opens your report.

Docmd.Maximize
 
Re. Cosmetic problem with previewing Reports

I have a Switchboard Form that opens a Popup(?) via a Query. This requests a date ( Enter parameter value) prior to previewing a Report. It is this Report preview that I would like to be displayed maximized,. Where would I enter the code: Docmd.Maximize?
 
Re. Cosmetic problem with previewing Reports

Further to my previous post, to make things a little clearer, the switchboard form has a button with the label 'Date'. Clicking this takes you to the popup: (Enter parameter value). Where do I enter the command Docmd.Maximize into this button?
 
' Open a report.
Case conCmdOpenReport
Screen.ActiveForm.Visible = False
DoCmd.OpenReport rst![Argument], acPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow
 
Re. Cosmetic problem with previewing Reports

Hi,
Thanks for the information.
Slight problem. When I said earlier that I'm fairly new to Access, I perhaps should have said that I'm a complete numbskull!
What do I do with that code, where do I put it?
Maybe you can suggest a more basic source of help for such as me. Access Help seems to have no solution. I got a big fat book (1500 pages): 'Special Edition. Using Access' that is full of similar code but which also is of no use in this case. In my innocence, I thought that such a basic thing as maximizing a report preview would be fairly straightforward. Seems not. Thanks anyway.
 
Re. Cosmetic problem with previewing Reports

Me again.
Ignore previous (frustrated) message.
Aha! So that's how you do it!
Many thanks for your help from a slightly less numbskulled newbie.
 

Users who are viewing this thread

Back
Top Bottom