Create an expression in a text box.

[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?

 

[Dirk Goldgar]

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?

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]

 

[Jeanette Cunningham]

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


Jeanette Cunningham