Error with IIF(IsNull([AgentName]),[Address2],[AgentAddress2]) 1

[Triacona]

Dear All,

Thank you for a great forum.
I seem to be getting an error on the following formulae within my report PolAcknowledgementLetter:

=IIf(IsNull([AgentName]),[Address2],[AgentAddress2])
=IIf(IsNull([AgentName]),[Address3],[AgentAddress3])
=IIf(IsNull([AgentName]),[Address4],[AgentAddress4])
etc...

The error occurs when the report is run.
It prints

#Error

in place of the text box.
Except this one works..!!

=IIf(IsNull([AgentName]),[Address1],[AgentAddress1])

And if the AgentName is not blank all the agents address lines get printed (1-5).

Please help
I just keep going around in circles.
Thank you for your forthcoming help.

Thank you,

Kind regards

Triacona

 

[dhookom]

Do you really have those field names in the record source of the report?

Duane
Hook'D on Access
MS Access MVP

 

[Triacona]

Dear Duane,

Thanks for your response.
Well to answer your question, when I just add Address1(2,3,4,5) with lable it displayes when a customer has an address, if the customer does not have an address then it is blank, the same for the AgentAddress1(2,3,4,5)

It is only when I use the formula that it does not display...
Please help
Thank you

Thank you,

Kind regards

Triacona

 

[dhookom]

This should work. What are the names of the text boxes? Have you confirmed they are not the same as a field name?

Duane
Hook'D on Access
MS Access MVP

 

[Triacona]

Dear Duane,

You are an ACE man!!
For some reason the report named the text box the same as the field names in question so caused the error!

Thank you again!
Have a star!


Thank you,

Kind regards

Triacona