make Report Header not visible from query parameter

  • Thread starter Thread starter Tom Ross
  • Start date Start date
T

Tom Ross

Hi

I have a report based on a parameter query [Start Unit], [End Unit] are the
parameters

I want to make the report header not visible based on the value of one of
the parameters.

What Event do I trap so I can inspect that parameter?

How do I set the visible property of the report header?

Tom
 
You can add a text box to your report header section:
Name: txtStartUnit
Control Source: =[Start Unit]
Then in the On Format event of the Report Header section, add code like:
Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
Cancel = Me.txtStartUnit > 4
End Sub
 
thanks. I appreciate the solution and so do the users of my databasees who
will not be as confused now.

Tom


Duane Hookom said:
You can add a text box to your report header section:
Name: txtStartUnit
Control Source: =[Start Unit]
Then in the On Format event of the Report Header section, add code like:
Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
Cancel = Me.txtStartUnit > 4
End Sub

--
Duane Hookom
MS Access MVP


Tom Ross said:
Hi

I have a report based on a parameter query [Start Unit], [End Unit] are
the
parameters

I want to make the report header not visible based on the value of one of
the parameters.

What Event do I trap so I can inspect that parameter?

How do I set the visible property of the report header?

Tom
Click to expand...
Click to expand...
 
Back
Top