Conditionally visible line

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
 
D

Duane Hookom

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)
 
Top