Condition to show the details area

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to place a condition on the details area of an report. Like
if this 'Required Quantity' field is larger than this 'Instock Quantity'
field then show detail area if not hide area.

Thanks for help....
 
JeffH13 said:
Is it possible to place a condition on the details area of an report. Like
if this 'Required Quantity' field is larger than this 'Instock Quantity'
field then show detail area if not hide area.
Click to expand...


Easy. Just use some VBA code in the detail section's Format
event procedure:

Cancel = (Me.[Required Quantity] <= [Instock Quantity])
 
Back
Top