|
| 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
April 2nd, 2010, 12:07 AM
posted to microsoft.public.access.forms
|
|||
|
|||
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
April 2nd, 2010, 12:19 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
April 2nd, 2010, 03:59 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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 | |
|
|
Linear Mode
