Multiple items in text box on a form?

  • Thread starter Thread starter Shakobe13
  • Start date Start date
S

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
 
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
Click to expand...

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"
 
Thank you very much.

John W. Vinson said:
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
Click to expand...

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"
Click to expand...
 
Back
Top