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

-- 
Message posted via http://www.accessmonster.com

upsman via AccessMonster.com wrote:

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

-- 
Marsh
MVP [MS Access]