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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Footer Code 5
Hide Line on Repeating Values 7
Trying to control when a line is displayed in a report. 8
Line at bottom of Detail section 7
Using VBA to hide a report's detail section? 1
Making the report footer not visible 3
Printing Selective Fields in Detail or Footer Section of Report 2
How make a control conditionally invisible? 1

Back
Top