Default view for Report vs acPreview etc

[shellfish]

When I add a cmd button and assign a report to open, it opens in full screen, and any its very clear and bright. Also web addresses can be clicked on and launched..just what I want...however...

As I want to have the report used by many buttons and filters, I have added event procedures to each combo box....

Private Sub Command193_Click()
DoCmd.OpenReport "POAP", acViewPreview, , "ID=" & Me.Combo188
End Sub

This works BUT when the report opens, its in print preview mode...ie. its small, is non continous and NOT WHAT I want !!!

What do I change to make acViewPreview simply look like a regular default macro? Its sending me insane :banghead:

 

[JHB]

Have you tried the different parameters for report view, like "acViewReport", "acViewNormal" (and "acViewPreview").
To maximize the report when it open, use the below code in the report open event:

Private Sub Report_Open(Cancel As Integer)
  DoCmd.Maximize
End Sub

 

[shellfish]

thats it ! acViewReport...

perfect

am not a programmer and have spent approx 27 years trying to find this !