If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple items in text box on a form?
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 |
#2
|
|||
|
|||
Multiple items in text box on a form?
On Thu, 1 Apr 2010 16:07:01 -0700, Shakobe13
wrote: 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" -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Multiple items in text box on a form?
Thank you very much.
"John W. Vinson" wrote: On Thu, 1 Apr 2010 16:07:01 -0700, Shakobe13 wrote: 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" -- John W. Vinson [MVP] . |
Thread Tools | |
Display Modes | |
|
|