Multiple items in text box on a form?

[Shakobe13]

I want a text box to display items from a table and text together?

so the MainTable collects quantity, color and price which is enter through
antother form.

I want a text box to display....

"You have chosen 8 red widgets at $4.00 each"

the 8, red and $4.00 getting pulled form a table.

can I do this? please help.

Thanks

 

[John W. Vinson]

I want a text box to display items from a table and text together?

so the MainTable collects quantity, color and price which is enter through
antother form.

I want a text box to display....

"You have chosen 8 red widgets at $4.00 each"

the 8, red and $4.00 getting pulled form a table.

can I do this? please help.

Thanks

Sure. It's simpler to have three textboxes (for the quantity, item and price),
but you can set the control source of a textbox to an expression like

= "You have chosen " & [Quantity] & " " & [Color] & " at " &
Format([UnitPrice], "currency") & " each"

 

[Shakobe13]

Thank you very much.

I want a text box to display items from a table and text together?

so the MainTable collects quantity, color and price which is enter through
antother form.

I want a text box to display....

"You have chosen 8 red widgets at $4.00 each"

the 8, red and $4.00 getting pulled form a table.

can I do this? please help.

Thanks

Sure. It's simpler to have three textboxes (for the quantity, item and price),
but you can set the control source of a textbox to an expression like

= "You have chosen " & [Quantity] & " " & [Color] & " at " &
Format([UnitPrice], "currency") & " each"