#Size Error - Report textbox

[MHamid]

Hello,

I have a formula in the Control Source of a textbox in an Access Report and I'm getting the #Size error when I view the report.

What am I missing in my formula? Am I supposed to be using an iferror function? If so, how? I tried it ealier and I'm still getting the #Size error message.

=IIf(Nz([Issue Name NEW])<>Nz([Issue Name OLD]),[Issue Name NEW],"")

Thank you

 

[Joe4]

What is actually in "Issue Name NEW" and "Issue Name OLD"
Can both of these be NULL or just one?
Note that if "Issue Name NEW" can be Null at the same time "Issue Name OLD" is not, you may have an issue since you are trying to return "Issue Name NEW".
So maybe try:

=IIf(Nz([Issue Name NEW])<>Nz([Issue Name OLD]),[COLOR=#ff0000][B]Nz([/B][/COLOR][Issue Name NEW][COLOR=#ff0000][B])[/B][/COLOR],"")

 

[Micron]

Does this involve a sub report? If a sub report has no records, it can generate this error when a report control is referencing the sub. IsError is a common way of dealing with this.