detail line question

[Susan]

Is there a way with expressions to control whether an individual detail line
shows or not in a report? I am not referring to suppressing all detail
lines in a report.

 

[Duane Hookom]

Most of us would do this with a little code that would either set the detail
section to invisible or cancel its printing. The code could reference either
the values of bound controls in the section or possibly the value of some
other object.

For instance, the On Format event of the detail section of a report could
reference a check box on some open form like:
Cancel = (Forms!frmPrintOptions!chkHideDetail = True)

 

[Marshall Barton]

Is there a way with expressions to control whether an individual detail line
shows or not in a report? I am not referring to suppressing all detail
lines in a report.

That record should be excluded using a criteria in the
report's record source query. The criteria might look
something like:
<> "the individual"

A far less useful approach would be to to use code in the
detail section's Format event:
Cancel = (Me.[the field] <> "the individual")