Suppressing a field during report production

[Howard Thompson]

I am building a simple database for my church membership. I am holding telephone numbers, but give the members the option of not printing this in the church directory which I am creating from the database.

To do this I have set a Boolean field called [Ex-Dir Home] which, when set to True, should suppress the printing of the contents of the field [Home Number]. I have set the following expression in various places in the Property Sheet:

=IIf([Ex-Dir Home]=True,[Home Number].[Visible]=No,[Home Number].[Visible]=Yes)

but I can't get it to work! Any ideas, please?

I also seem to have set an empty Macro somewhere by mistake, as every time I run the report I get a Dialogue box asking for a Parameter Value. The report runs if I just enter "OK". How do I find this Macro to remove it?

 

[arnelgp]

where are you using this expression, in a query:

IIf([Ex-Dir Home]=True,[Home Number], "")

in a report control:
=IIf([Ex-Dir Home]=True,[Home Number], "")

this will blank out the numbers.

 

[JHB]

...
I also seem to have set an empty Macro somewhere by mistake, as every time I run the report I get a Dialogue box asking for a Parameter Value. The report runs if I just enter "OK". How do I find this Macro to remove it?

Do you've a query as "Record Source" for the report?
What Parameter value does it ask for?

 

[Howard Thompson]

Thanks arnelgp. I got it working! Brilliant!

Howard

 

[Howard Thompson]

Thanks JRB for your interest, but it turned out to be a syntax error in my code!