IIF filter statement does not when No data is in a field. 1

[MikeFL]

I’m working on an MS Access2003 database form where I have a “TEXT” filed named “CatCPIReqNos”. This field can contain data or not depending on the users input.

I have another field “unbound" named "Text391" that I have the following IIF statement (1) in that returns its IIF statement if field “CatCPIReqNos” contains NO data in it. But I want the IIF statement (2) to return its IIF statement if field “CatCPIReqNos” "HAS" data in and I can’t seam to make it work. Can someone please help me?

(1):

=IIf(IsNull([CatCPIReqNos]),"-> Please make sure that you put our above [TAR] No. in the Cat DSN “Request Detail” field for our future reference! 
",([CatCPIReqNos])=" ")

(2):

=IIf(IsNotNull([CatCPIReqNos]),"-> Please make sure that you put our above [TAR] No. in the Cat DSN “Request Detail” field for our future reference! 
",([CatCPIReqNos])=" ")

Note: Also when I try to use the IIF statement (2) I see the following error: #name# in the “Text391” field.

 

[Remou]

Hi
I think:
[tt]=IIf(Not IsNull([CatCPIReqNos]),"-> Please make sure that you put our above [TAR] No. in the Cat DSN “Request Detail” field for our future reference!
",([CatCPIReqNos])=" ")[/tt]

 

[MikeFL]

Remou: Thanks what you suggested worked!