make a text box only appear if txtEmployee IS NOT Blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make a text box (txtfinal) that has an expression like this:
If "txt1" >8, then subtract 8 from "txt1"
and also if lstName is null then txtFinal is null also

"txt1" is a text box from a form that has a mathematical equation on it.
the final number is imported into the "txtFinal" if the number is greater
than 8 it needs to have 8 subtracted from it.

"lstName" is a list box on the same report with user name in it. It
references a specific user ID and Name from a form. (if this value is null,
then the "txtFinal" does not need to appear).

The key is that I cannot get the txtFinal to ONLY APPEAR IF NEEDED (if
txtName IS NOT Blank. I have tried for weeks to figure out the code to work
but cannot figure it out..... please help.....
 
Back
Top