Condition to show the details area

J

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

Marshall Barton

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