show text box if another textbox is null

[smile]

I need to create a report in it I have a textbox1 that I etiher fill or not by entering data into table.

IF textbox 1 is null I need the report to display text "Pending" I entered in textbox2 on the report. IF textbox1 has text in it the texbox2 should not be displayed.

 

[pbaldy]

You can use the Nz() function.

 

[smile]

You can use the Nz() function.

But textbox2 that I need to hide if textbox1 is empty is unbound, where do I need to enter the function then?

 

[pbaldy]

Actually this might be better:

=IIf(IsNull(Textbox1), "Pending", "")

 

[smile]

Actually this might be better:

=IIf(IsNull(Textbox1), "Pending", "")

I got the expression you entered contains invalid syntax error.

I try to clear things out a bit.

textbox1 is unbound textbox on a report
textbox2 is from table with text

If textbox2 is null then I need to hide textbox1 that I filled with text "Pending"
IF I try to paste iif function to unbount textbox1 I get syntax error.

What am I doing wrong?

 

[pbaldy]

It looks like I reversed the names, but I figured you would study the function, see what it's doing, thus be able to fix it. Can you post a sample db?

 

[smile]

It looks like I reversed the names, but I figured you would study the function, see what it's doing, thus be able to fix it. Can you post a sample db?

I got it working with =IIf([Text62] Is Not Null;"Pending")