how to hide some information in a report

[Teresa]

in a donor database I want to make reports, but leave out addresses if they don't want to be acknowledged. Can't figure out how to only hide those particular addresses. Or do I have to start all over and delete those addresses from the database altogether? That would be unbelievable! Help!!

[ranman256]

dont put the address in the report.
in the query, put only the fields you want shown.

[June7]

You want to show some addresses? Need a field in db that indicates whether or not to show (can be a Y/N field). Then use expression in query or textbox:

IIf([Show], [Address], Null)

[Teresa]

June7,
Thanks for reply. I have a checkmark field in the database for when donor requests acknowledgement. Would I need another field? And where would I use this expression IIf([Show], [Address], Null) in the query?

[June7]

Why would you need another field? Sounds like the 'checkmark' field would be the [Show] field in my example. The expression can go in query or textbox.

[ranman256]

yes, a chkShowAddr box would render the address subreport invisible.

sub On_Print()
subRpt.visible = chkShowAddr.value
end sub

[June7]

Yes, can use VBA but I try to avoid VBA behind report.