Conditionally visible line

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Hello,

Is there a way to set the visibility of a line that is located in the detail
section of a report according to a value in the current record? The line's
visible property does not seem to accept a formula.

Regards,

Jack
 
If you have a control in your report's detail section like

Name: txtMaxFlowRate
Control Source: [MaxFlowRate]
and a line:
Name: linMaxFlowRate

You can add code to the On Format event of the detail section like:
Me.linMaxFlowRate.Visible = (Me.txtMaxFlowRate > 2000)
 
Back
Top