Report preview goes under the Form

[Jeff A via AccessMonster.com]

Hi,

I have a form that's been set to fit the entire screen, hiding the desktop
beneath it (including the Start taskbar). To do this, I made the form as
modal, popup, no borderstyle, no minmax and close buttons (there's a command
button on the form that replaces this function), etc. And I used some API to
hide the Access window itself.

However, there's a command button on the form that when clicked, is supposed
to popup a report (it's on preview mode). The problem is, I think because of
my form settings, the report previews underneath the form, so the user can't
see it all. If I change the form settings back to its "normal" state, then
the report popups fine.

I would like the report to popup on top of the maximized, modal, popup form
but i'm not sure which settings to tinker. I'm using Access 2000 and I can't
seem to set the popup and modal properties of the report.

Any ideas on a workaround?

Thanks, jeff

 

[fredg]

Hi,

I have a form that's been set to fit the entire screen, hiding the desktop
beneath it (including the Start taskbar). To do this, I made the form as
modal, popup, no borderstyle, no minmax and close buttons (there's a command
button on the form that replaces this function), etc. And I used some API to
hide the Access window itself.

However, there's a command button on the form that when clicked, is supposed
to popup a report (it's on preview mode). The problem is, I think because of
my form settings, the report previews underneath the form, so the user can't
see it all. If I change the form settings back to its "normal" state, then
the report popups fine.

I would like the report to popup on top of the maximized, modal, popup form
but i'm not sure which settings to tinker. I'm using Access 2000 and I can't
seem to set the popup and modal properties of the report.

Any ideas on a workaround?

Thanks, jeff

Just hide the form when you open the report.
Code the command button
DoCmd.OpenReport "ReportName", acViewPreview
Me.Visible = False

Then code the report's Close event:
forms!FormName.Visible = True

 

[Jeff A via AccessMonster.com]

Ok, i'll try it later. thankz!

Hi,

[quoted text clipped - 17 lines]

Thanks, jeff

Just hide the form when you open the report.
Code the command button
DoCmd.OpenReport "ReportName", acViewPreview
Me.Visible = False

Then code the report's Close event:
forms!FormName.Visible = True