Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

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

    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.
    Charlotte

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    Thanks Charlotte, your solution works like a charm.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •