How do I prevent a cell from printing in Access?

[Don 969]

Using MS Access 2003 Professional.
I have a membership table with names, addresses, phone #, etc. A member can
say, you can release all the information I have given you except the e-mail
address to our club web site. I now want to send this member's record with no
e-mail address. Any suggestions?

 

[fredg]

Using MS Access 2003 Professional.
I have a membership table with names, addresses, phone #, etc. A member can
say, you can release all the information I have given you except the e-mail
address to our club web site. I now want to send this member's record with no
e-mail address. Any suggestions?

How are you indicating to Access that a particular member doesn't want
his email given out?
Add a Field to your table (a Yes/No check box is fine).
Add it to your member entry form.
Check the box for each member that wants to restrict his email
address.

Include this check box in the report's record source.
Then using an unbound control:
=IIf([RestrictCheckBox]=True,"",[EmailAddress])