How do I create If "yes" then address for that record will not

[Guest]

I am confused.

I am working with addresses and producing a directory through a series of
reports.

One person would like their name in the directory but not any of their
contact details. In an effort to record this, I created a yes/no field for
privacy.

What I want to know is how I code the query (that my report will use) so
that when this privacy field is "yes", the contact details for that
particular record won't show.

How do I do this??? Or is there a better/easier way to do this than using a
yes/no field?

 

[Steve Schapel]

Kat,

Using a Yes/No field like this is not a bad way of going about it.

Construct calculated fields in the query like this...

ReportAddress: IIf([Privacy],Null,[Address])
ReportPhone: IIf([Privacy],Null,[Phone])

 

[Steve Schapel]

Yes, Eric, that would be another way of doing it. It would be the
Formay event of the applicable report *section*. Your code could be
simplified to:
Me.Address.Visible = Me.YesNoField

I would prefer to do it in the query.

 

[missinglinq via AccessMonster.com]

I just HAVE to ask; what's the point in being listed in a "directory" if no
contact information is given?