Help with maximizing reports from parameter

[freddienet]

I am running a parameter query at the report level. The report runs fine but I cannot get the report to maximize on opening. I have put the maximize command in the code for the button. It will not maximize. Maybe I am putting it in the wrong place.

Any help would be appreciated.

Freddie

 

[pbaldy]

This always works for me, behind a button:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.Maximize

 

[Geneo]

Maximize

Maybe you should use set macro to open your report
1. choose "open report" and in the box choose the report wished.
2. choose "maximize"
3. save new macro

This must work. I wish you luck.

Geneo

 

[pbaldy]

From a PM:

I am very new to adding code. When you say behind button what do you mean? The code that executes the report to open the report. May be could give me an example of where to put it. Maybe the section name or some ID location.

I put the command in the select case section. I notices when I pasted the command in there and added the report name the blue letters "CASE" at the beginning of the line turned red.

I also put it in several other locations and I still can not get it to work.

Thanks for you help.

Freddie

From your original post, I gathered that you already had the code to open the report behind a button on a form. I would just add the "DoCmd.Maximize" line immediately after the line opening the report, as in my example above.

It is much easier to debug code problems when you can see the code. Typically the red would indicate that something you added violated the syntax or structure required. It would help if you post the offending sub.