????? Need Help

  • Thread starter Thread starter Penny
  • Start date Start date
P

Penny

I have four text boxes with currency values. I have
another text box where customer names are shown. How would
I code the text box with the customer name not to show up
if all of the other four text boxes have a currency value
of 0.00?

Thanks in advance!!!!
 
I have four text boxes with currency values. I have
another text box where customer names are shown. How would
I code the text box with the customer name not to show up
if all of the other four text boxes have a currency value
of 0.00?

Thanks in advance!!!!
Click to expand...
Penny,
Use an unbound control.
Set it's control source to:
=IIf(IsNull([Currenct1]) and IsNull([Currency2]) and
IsNull([Currenct3]) and IsNull([Currency4]),"",[CustomerName])
 
Back
Top