Making a report the focus

[MarkWaddington]

Hi,

Could someone tell me how I bring a report to focus? (I.e. bring it to view so it's not stuck behind some form).

I tried Reports!ReportTitle.SetFocus and it didn't work.

Many thanks,

Mark Waddington.

 

[Darrylles]

Hi Mark,

Is the calling form a 'Pop-up'?

If so, then the form will always stay 'on-top'.

Hide the form before calling the report, shoew the form just before the report is closed.

Hope this helps.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[gusbrunston]

[tt]
Hi Mark:

I have a master report menu. When I click on a command button (really a label) to look at a particular report, I open the report in preview mode. Here's the code for one such report:

Private Sub Label35_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
On Error GoTo Err_Label35_MouseUp
Dim stDocName As String
stDocName = "rptThreeLiner"
DoCmd.OpenReport stDocName, acPreview
Exit_Label35_MouseUp:
Exit Sub
Err_Label35_MouseUp:
MsgBox Err.Description
Resume Exit_Label35_MouseUp
End Sub

That preview of the report fills the screen, covering all that's behind it. Then it's either closed or printed from the File=>Print Menu.

I hope this is helpful. Gus Brunston An old PICKer, using Access2000
[tt]Want solutions you can understand?
Post understandable questions.[/tt]

 

[gusbrunston]

[tt]
Hi Darrylle:

Our messages crossed in the mail. I don't disagree with you at all.

Cheers, Gus Brunston An old PICKer, using Access2000
[tt]Want solutions you can understand?
Post understandable questions.[/tt]

 

[Darrylles]

Gus,

LOL

No prob - happens to me all the time when thinking about solution and messing with code.

Cheers,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."