create an optional row of a report

[Carole]

Is there a way to create a row on a report that is optional?

I'm trying to improve an existing report , that is generated from a link
table. what i would like to have is if certain columns are not null ( have
values) print an extra row right underneath that row, showing this
information. Is this possible in MS Access? Anyone have any idea how to
accomplish this?

 

[Duane Hookom]

You could create a second detail section below the first. To do this add a
lowest level of sorting and grouping based on the primary/unique fields in
the report's record source. Display the footer for this group. This is you
second detail section.

You can add invisible controls in this section bound to "certain columns".
In the On Format code for this section, enter something like:
Cancel = IsNull(Me.txtA) AND IsNull(Me.txtB)
You will have to modify the above expression to meet your specs.

 

[Carole]

AWESOME, Thank you so much!

You could create a second detail section below the first. To do this add a
lowest level of sorting and grouping based on the primary/unique fields in
the report's record source. Display the footer for this group. This is you
second detail section.

You can add invisible controls in this section bound to "certain columns".
In the On Format code for this section, enter something like:
Cancel = IsNull(Me.txtA) AND IsNull(Me.txtB)
You will have to modify the above expression to meet your specs.