Excluding Email address from a report

[Robin Chapple]

I run a membership database and produce a birthday report each month
which includes the member's email address.

Some of our members, understandably, do not want their email address
published.

I have a Yes/No field [EmailConsent] that indicates YES if they are
willing for me to publish their address

My report uses this to show the email address.

="Email Address " & "<" & & ">"

How do I use the [EmailConsent] field to control the exclusion? The
intention being to have no content at all.

Thanks,

Robin Chapple

 

[Wayne Gillespie]

I run a membership database and produce a birthday report each month
which includes the member's email address.

Some of our members, understandably, do not want their email address
published.

I have a Yes/No field [EmailConsent] that indicates YES if they are
willing for me to publish their address

My report uses this to show the email address.

="Email Address " & "<" & & ">"

How do I use the [EmailConsent] field to control the exclusion? The
intention being to have no content at all.

Thanks,

Robin Chapple
[/QUOTE]

Use an IIF (immediate if) statement in your control source to check the value of [EmailConsent] -

=IIF([EmailConsent]=True,"Email Address " & "<" & [email] & ">","Not Shown")

Change "Not Shown" to whatever you want to display when [EmailConsent]=False, or use Null or "" to have it display blank.


Wayne Gillespie
Gosford NSW Australia