Conditional paragraphs in a report

[Mike Langensiepen]

How can I get conditional paragraphs in a report. Depending on the value of
a field in a record, I need a paragraph to be selected and printed in the
report.

Thanks

Mike

 

[Arvin Meyer [MVP]]

If you can do it in a query, then the report will not need code. If you do
have to use code to show or hide the label containing your paragraphs, use
the OnFormat event of the detail section.

 

[Mike Langensiepen]

Thanks for the suggestion.

If you can do it in a query, then the report will not need code. If you do
have to use code to show or hide the label containing your paragraphs, use
the OnFormat event of the detail section.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

Hi Mike,

In the On Format event of your report, have something like this:

if me.FIELD = VALUE_EXPECTED then
me.PARAGRAPHNAME.visible = true
else
me.PARAGRAPHNAME.visible = false
end if

Hope this helps.

Damian.