Print Detail section only conditionally

[upsman via AccessMonster.com]

I have a report that I run from a query. The report is divided into 3
sections. The 1st two sections will always print but the third section may
or may not print depending on whether a name field is filled-in or not. I
have placed the 1st two sections into individual group header sections on the
report and the 3rd section I put in the Detail section. How do I get the
Detail section of the report to print only if my name field is filled-in? I
don't see an 'On No Data' event in the Detail section so I don't know how to
stop it from printing if it doesn't need to. If what I've done is not the
best or proper way to do it , please let me know. I just need to print the
1st sections all the time but the 3rd section only sometimes.

Thanks,
Rod

 

[Marshall Barton]

I have a report that I run from a query. The report is divided into 3
sections. The 1st two sections will always print but the third section may
or may not print depending on whether a name field is filled-in or not. I
have placed the 1st two sections into individual group header sections on the
report and the 3rd section I put in the Detail section. How do I get the
Detail section of the report to print only if my name field is filled-in? I
don't see an 'On No Data' event in the Detail section so I don't know how to
stop it from printing if it doesn't need to. If what I've done is not the
best or proper way to do it , please let me know. I just need to print the
1st sections all the time but the 3rd section only sometimes.

Just cancel the detail section's Format event when the name
is missing. Maybe all you need is:

Cancel = IsNull([name field])