Create an expression in a text box.

  • Thread starter Thread starter p-rat
  • Start date Start date
P

p-rat

I have a text box on my form. I want to create an expression for a
line item total (unit price * quantity * surcharge). I don't see the
row source in the properties for a text box. How can I do this?
 
p-rat said:
I have a text box on my form. I want to create an expression for a
line item total (unit price * quantity * surcharge). I don't see the
row source in the properties for a text box. How can I do this?
Click to expand...


It's the ControlSource (or Control Source) property that you want, on the
Data tab of the text box's property sheet. For example you could set that
property to:

=[unit price] * [quantity] * [surcharge]
 
Use the control source of an unbound textbox like this:
=unit price * quantity * surcharge


Jeanette Cunningham
 
Back
Top