docmd.maximize

[mbamber]

Hi all,

This is driving me mad!

I currently have a report in my database which, when opened, should maximize.

Private Sub Report_Open(Cancel As Integer)

'Maximise the window
DoCmd.Maximize

End Sub

Every time this runs, my report looks like picture123.png

To actually view the data I have to click everywhere on my report and it appears one bit at a time.

I think the problem lies with the event that

docmd.maximize

is placed in.

Please help!!!!

TIA

 

[Roku]

Try this:

Private Sub Report_Load()
DoCmd.SelectObject acReport, Me.Name
DoCmd.Maximize
End Sub

I used the Load event, rather than the Open event on one of my reports and it worked OK. You need the DoCmd.SelectObject to make the form the subject of DoCmd>Maximize.

 

[mbamber]

Unfortunately, this doesn't work

It seems to be fine, unless I set pop up to Yes. Then it breaks...

 

[Roku]

Unfortunately, this doesn't work

It seems to be fine, unless I set pop up to Yes. Then it breaks...

If I understand you correctly, it works in normal window mode, but not in pop-up mode? I didn't see the pop-up part in your original post - is that a requirement? If so, why?

When it breaks, how does it break?

Do you still have the problem with the window not rendering correctly? If so, is this in both window modes?

 

[mbamber]

It does have to pop up, but it just wont show anything unless I click everywhere on the screen.

Anyway, I got around it by requerying the form after 5ms, and then setting the timer interval back to 0. This sort of works.

Thanks anyway.