make a text box only appear if txtEmployee IS NOT Blank

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Walter Mills - 16 Jan 2006 14:45 GMT

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.....

Reply to this Message

tina - 16 Jan 2006 15:46 GMT

already answered in your duplicate post in
microsoft.public.access.modulesdaovba on this date.
please do not multi-post. see
http://home.att.net/~california.db/tips.html#aTip10 for more information.

hth

> I need to make a text box (txtfinal) that has an expression like this:
> If "txt1" >8, then subtract 8 from "txt1"
[quoted text clipped - 11 lines]
> txtName IS NOT Blank. I have tried for weeks to figure out the code to work
> but cannot figure it out..... please help.....

Reply to this Message