Condition to show the details area

[JeffH13]

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....

 

[Marshall Barton]

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.

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

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