Report not in focus (2K (SR-1))

Topic

New Reply

I have a report preview control in a form. When I activate the control, a preview of the report will appear on the screen, but behind the form (partly hidden) and I have to minimize the form to see the full preview. Can I make the report preview in focus after pressing the control so that a user has to close the preview before returning to the form? Please help.

Reply | Quote

Replies

By any chance, is this a Dialog form on which the Pop-Up Property is set to yes? If so, the form remains on top of all other Microsoft Access windows. Set the Pop-Up Property to No.

Reply | Quote

In the code that opens the report, you can hide the form and allow the report to get the focus by adding a line like this:

Me.visible = False

In the Close event of the report, make the form visible again by doing something like this:

Forms!MyForm.visible = True

Where MyForm should be replaced by the actual name of the form. Another method is to use SelectObject and select the hidden form. That will automatically make it visible.

Reply | Quote

Thanks Charlotte, your solution works like a charm.

Reply | Quote