detail line question

  • Thread starter Thread starter Susan
  • Start date Start date
S

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.
 
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)
 
Susan said:
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.
Click to expand...


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")
 
Back
Top