How to accumulate text in a combobox? | | |
Hi,
Each time the user selects an item from a combobox, I want that string to
get appended to the values that were already selected. The result is that
the combo is accumulating text each time the user selects an item from its
list. I want the delete and backspace keys to function normally, as well
as all the other properties of the combobox.
Does anybody know the easiest way to do this?
Thanks!
Norm
| | | | re: How to accumulate text in a combobox?
On Sun, 19 Sep 2004 16:22:11 -0500, Norm wrote:
[color=blue]
> Hi,
>
> Each time the user selects an item from a combobox, I want that string to
> get appended to the values that were already selected. The result is that
> the combo is accumulating text each time the user selects an item from its
> list. I want the delete and backspace keys to function normally, as well
> as all the other properties of the combobox.
>
> Does anybody know the easiest way to do this?
>
> Thanks!
> Norm[/color]
Code the Combo Box AfterUpdate event:
[ControlName] = [ControlName] & Me![ComboName]
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
| | | | re: How to accumulate text in a combobox?
fredg <fgutkind@example.invalid> wrote in
news:1frgmpkizyzoq.ten75vexc8mb.dlg@40tude.net:
[color=blue]
> On Sun, 19 Sep 2004 16:22:11 -0500, Norm wrote:
>[color=green]
>> Hi,
>>
>> Each time the user selects an item from a combobox, I want that
>> string to get appended to the values that were already selected. The
>> result is that the combo is accumulating text each time the user
>> selects an item from its list. I want the delete and backspace keys
>> to function normally, as well as all the other properties of the
>> combobox.
>>
>> Does anybody know the easiest way to do this?
>>
>> Thanks!
>> Norm[/color]
>
> Code the Combo Box AfterUpdate event:
> [ControlName] = [ControlName] & Me![ComboName][/color]
Hi Fred,
Thanks for the reply, but that's not quite right. [ControlName] and Me!
[ComboName] both contain the new value selected by the user. The result
is that the old value gets lost and the combo becomes equal to the new
value string & the new value string.
Norm
| | | | re: How to accumulate text in a combobox?
On Sun, 19 Sep 2004 17:26:05 -0500, Norm wrote:
[color=blue]
> fredg <fgutkind@example.invalid> wrote in
> news:1frgmpkizyzoq.ten75vexc8mb.dlg@40tude.net:
>[color=green]
>> On Sun, 19 Sep 2004 16:22:11 -0500, Norm wrote:
>>[color=darkred]
>>> Hi,
>>>
>>> Each time the user selects an item from a combobox, I want that
>>> string to get appended to the values that were already selected. The
>>> result is that the combo is accumulating text each time the user
>>> selects an item from its list. I want the delete and backspace keys
>>> to function normally, as well as all the other properties of the
>>> combobox.
>>>
>>> Does anybody know the easiest way to do this?
>>>
>>> Thanks!
>>> Norm[/color]
>>
>> Code the Combo Box AfterUpdate event:
>> [ControlName] = [ControlName] & Me![ComboName][/color]
>
> Hi Fred,
>
> Thanks for the reply, but that's not quite right. [ControlName] and Me!
> [ComboName] both contain the new value selected by the user. The result
> is that the old value gets lost and the combo becomes equal to the new
> value string & the new value string.
>
> Norm[/color]
You are not correct in your statement.
Perhaps you should try it first, or perhaps you tried it but you did
not write the expression properly.
[ControlName] = [ControlName] & Me![ComboName]
If you select 3 items, one at a time, from a combo box, the result in
the text box will be the 3 items, one after the other.
Select Yes, then Maybe, then No, and the text box will read
YesMaybeNo.
If you incorrectly wrote:
[ControlName] = Me!ComboName
then you would see only the last item selected.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
| | | | re: How to accumulate text in a combobox?
fredg <fgutkind@example.invalid> wrote in
news:1cd9436v0yz9v.6feh64v5juqb$.dlg@40tude.net:
[color=blue]
> On Sun, 19 Sep 2004 17:26:05 -0500, Norm wrote:
>[color=green]
>> fredg <fgutkind@example.invalid> wrote in
>> news:1frgmpkizyzoq.ten75vexc8mb.dlg@40tude.net:
>>[color=darkred]
>>> On Sun, 19 Sep 2004 16:22:11 -0500, Norm wrote:
>>>
>>>> Hi,
>>>>
>>>> Each time the user selects an item from a combobox, I want that
>>>> string to get appended to the values that were already selected.
>>>> The result is that the combo is accumulating text each time the
>>>> user selects an item from its list. I want the delete and
>>>> backspace keys to function normally, as well as all the other
>>>> properties of the combobox.
>>>>
>>>> Does anybody know the easiest way to do this?
>>>>
>>>> Thanks!
>>>> Norm
>>>
>>> Code the Combo Box AfterUpdate event:
>>> [ControlName] = [ControlName] & Me![ComboName][/color]
>>
>> Hi Fred,
>>
>> Thanks for the reply, but that's not quite right. [ControlName] and
>> Me! [ComboName] both contain the new value selected by the user. The
>> result is that the old value gets lost and the combo becomes equal to
>> the new value string & the new value string.
>>
>> Norm[/color]
>
> You are not correct in your statement.
>
> Perhaps you should try it first, or perhaps you tried it but you did
> not write the expression properly.
> [ControlName] = [ControlName] & Me![ComboName]
> If you select 3 items, one at a time, from a combo box, the result in
> the text box will be the 3 items, one after the other.
> Select Yes, then Maybe, then No, and the text box will read
> YesMaybeNo.
>
> If you incorrectly wrote:
> [ControlName] = Me!ComboName
> then you would see only the last item selected.
>[/color]
Thanks again for your reply.
I think the problem is that I didn't fully explain what I'm trying to
do. I want to update the selected text in the combo with the
accumulated values. So...[ControlName] = [ComboName]. Using your
expression, it would be [ComboName] = [ComboName] & Me![ComboName].
I did try your expression and I'm not getting the correct result.
Any other ideas?
Norm
| | | | re: How to accumulate text in a combobox?
On Sun, 19 Sep 2004 20:45:10 -0500, Norm wrote:
[color=blue]
> fredg <fgutkind@example.invalid> wrote in
> news:1cd9436v0yz9v.6feh64v5juqb$.dlg@40tude.net:
>[color=green]
>> On Sun, 19 Sep 2004 17:26:05 -0500, Norm wrote:
>>[color=darkred]
>>> fredg <fgutkind@example.invalid> wrote in
>>> news:1frgmpkizyzoq.ten75vexc8mb.dlg@40tude.net:
>>>
>>>> On Sun, 19 Sep 2004 16:22:11 -0500, Norm wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> Each time the user selects an item from a combobox, I want that
>>>>> string to get appended to the values that were already selected.
>>>>> The result is that the combo is accumulating text each time the
>>>>> user selects an item from its list. I want the delete and
>>>>> backspace keys to function normally, as well as all the other
>>>>> properties of the combobox.
>>>>>
>>>>> Does anybody know the easiest way to do this?
>>>>>
>>>>> Thanks!
>>>>> Norm
>>>>
>>>> Code the Combo Box AfterUpdate event:
>>>> [ControlName] = [ControlName] & Me![ComboName]
>>>
>>> Hi Fred,
>>>
>>> Thanks for the reply, but that's not quite right. [ControlName] and
>>> Me! [ComboName] both contain the new value selected by the user. The
>>> result is that the old value gets lost and the combo becomes equal to
>>> the new value string & the new value string.
>>>
>>> Norm[/color]
>>
>> You are not correct in your statement.
>>
>> Perhaps you should try it first, or perhaps you tried it but you did
>> not write the expression properly.
>> [ControlName] = [ControlName] & Me![ComboName]
>> If you select 3 items, one at a time, from a combo box, the result in
>> the text box will be the 3 items, one after the other.
>> Select Yes, then Maybe, then No, and the text box will read
>> YesMaybeNo.
>>
>> If you incorrectly wrote:
>> [ControlName] = Me!ComboName
>> then you would see only the last item selected.
>>[/color]
>
> Thanks again for your reply.
>
> I think the problem is that I didn't fully explain what I'm trying to
> do. I want to update the selected text in the combo with the
> accumulated values. So...[ControlName] = [ComboName]. Using your
> expression, it would be [ComboName] = [ComboName] & Me![ComboName].
>
> I did try your expression and I'm not getting the correct result.
>
> Any other ideas?
>
> Norm[/color]
You're correct. I did misread your request, and thought you wanted to
add text to a control,(a common procedure) based upon selections in
the combo box.
It seems like a rather strange request and makes no sense to me.
You already have a at least one value in the combo (let's say "Joe)
that you select, and you want to change the value in the combo to
"JoeJoe"?
And then what? "JoeJoeJoeJoe".
The usual purpose of a combo is to select a value and insert into a
control or field not into itself.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
| | | | re: How to accumulate text in a combobox?
fredg <fgutkind@example.invalid> wrote in
news:16w7fwa0tzrjr$.ol6rwz7c5ug6.dlg@40tude.net:
[color=blue]
> On Sun, 19 Sep 2004 20:45:10 -0500, Norm wrote:
>[color=green]
>> fredg <fgutkind@example.invalid> wrote in
>> news:1cd9436v0yz9v.6feh64v5juqb$.dlg@40tude.net:
>>[color=darkred]
>>> On Sun, 19 Sep 2004 17:26:05 -0500, Norm wrote:
>>>
>>>> fredg <fgutkind@example.invalid> wrote in
>>>> news:1frgmpkizyzoq.ten75vexc8mb.dlg@40tude.net:
>>>>
>>>>> On Sun, 19 Sep 2004 16:22:11 -0500, Norm wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> Each time the user selects an item from a combobox, I want that
>>>>>> string to get appended to the values that were already selected.
>>>>>> The result is that the combo is accumulating text each time the
>>>>>> user selects an item from its list. I want the delete and
>>>>>> backspace keys to function normally, as well as all the other
>>>>>> properties of the combobox.
>>>>>>
>>>>>> Does anybody know the easiest way to do this?
>>>>>>
>>>>>> Thanks!
>>>>>> Norm
>>>>>
>>>>> Code the Combo Box AfterUpdate event:
>>>>> [ControlName] = [ControlName] & Me![ComboName]
>>>>
>>>> Hi Fred,
>>>>
>>>> Thanks for the reply, but that's not quite right. [ControlName]
>>>> and Me! [ComboName] both contain the new value selected by the
>>>> user. The result is that the old value gets lost and the combo
>>>> becomes equal to the new value string & the new value string.
>>>>
>>>> Norm
>>>
>>> You are not correct in your statement.
>>>
>>> Perhaps you should try it first, or perhaps you tried it but you did
>>> not write the expression properly.
>>> [ControlName] = [ControlName] & Me![ComboName]
>>> If you select 3 items, one at a time, from a combo box, the result
>>> in the text box will be the 3 items, one after the other.
>>> Select Yes, then Maybe, then No, and the text box will read
>>> YesMaybeNo.
>>>
>>> If you incorrectly wrote:
>>> [ControlName] = Me!ComboName
>>> then you would see only the last item selected.
>>>[/color]
>>
>> Thanks again for your reply.
>>
>> I think the problem is that I didn't fully explain what I'm trying to
>> do. I want to update the selected text in the combo with the
>> accumulated values. So...[ControlName] = [ComboName]. Using your
>> expression, it would be [ComboName] = [ComboName] & Me![ComboName].
>>
>> I did try your expression and I'm not getting the correct result.
>>
>> Any other ideas?
>>
>> Norm[/color]
>
> You're correct. I did misread your request, and thought you wanted to
> add text to a control,(a common procedure) based upon selections in
> the combo box.
>
> It seems like a rather strange request and makes no sense to me.
> You already have a at least one value in the combo (let's say "Joe)
> that you select, and you want to change the value in the combo to
> "JoeJoe"?
> And then what? "JoeJoeJoeJoe".
> The usual purpose of a combo is to select a value and insert into a
> control or field not into itself.
>[/color]
Yes, that is exactly what I want to do. The reason is that the user is
selecting multiple items from the combo, and all of their selections
need to be captured in this string. I don't have the space to use
checkboxes or radio buttons to select these items, and have many combos
on the form. By selecting multiple items in the combo and concatenating
them into one string, the user can assemble whatever string they desire
into the combo. Unfortunately, I believe this is really the way I need
to do it.
Any ideas on how?
Norm
| | | | re: How to accumulate text in a combobox?
Norm <odin231@comcast.net> wrote in
news:Xns956A1F11EC68odin231comcastnet@216.196.97.1 36:
[color=blue]
> fredg <fgutkind@example.invalid> wrote in
> news:16w7fwa0tzrjr$.ol6rwz7c5ug6.dlg@40tude.net:
>[color=green]
>> On Sun, 19 Sep 2004 20:45:10 -0500, Norm wrote:
>>[color=darkred]
>>> fredg <fgutkind@example.invalid> wrote in
>>> news:1cd9436v0yz9v.6feh64v5juqb$.dlg@40tude.net:
>>>
>>>> On Sun, 19 Sep 2004 17:26:05 -0500, Norm wrote:
>>>>
>>>>> fredg <fgutkind@example.invalid> wrote in
>>>>> news:1frgmpkizyzoq.ten75vexc8mb.dlg@40tude.net:
>>>>>
>>>>>> On Sun, 19 Sep 2004 16:22:11 -0500, Norm wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> Each time the user selects an item from a combobox, I want that
>>>>>>> string to get appended to the values that were already selected.
>>>>>>> The result is that the combo is accumulating text each time the
>>>>>>> user selects an item from its list. I want the delete and
>>>>>>> backspace keys to function normally, as well as all the other
>>>>>>> properties of the combobox.
>>>>>>>
>>>>>>> Does anybody know the easiest way to do this?
>>>>>>>
>>>>>>> Thanks!
>>>>>>> Norm
>>>>>>
>>>>>> Code the Combo Box AfterUpdate event:
>>>>>> [ControlName] = [ControlName] & Me![ComboName]
>>>>>
>>>>> Hi Fred,
>>>>>
>>>>> Thanks for the reply, but that's not quite right. [ControlName]
>>>>> and Me! [ComboName] both contain the new value selected by the
>>>>> user. The result is that the old value gets lost and the combo
>>>>> becomes equal to the new value string & the new value string.
>>>>>
>>>>> Norm
>>>>
>>>> You are not correct in your statement.
>>>>
>>>> Perhaps you should try it first, or perhaps you tried it but you
>>>> did not write the expression properly.
>>>> [ControlName] = [ControlName] & Me![ComboName]
>>>> If you select 3 items, one at a time, from a combo box, the result
>>>> in the text box will be the 3 items, one after the other.
>>>> Select Yes, then Maybe, then No, and the text box will read
>>>> YesMaybeNo.
>>>>
>>>> If you incorrectly wrote:
>>>> [ControlName] = Me!ComboName
>>>> then you would see only the last item selected.
>>>>
>>>
>>> Thanks again for your reply.
>>>
>>> I think the problem is that I didn't fully explain what I'm trying
>>> to do. I want to update the selected text in the combo with the
>>> accumulated values. So...[ControlName] = [ComboName]. Using your
>>> expression, it would be [ComboName] = [ComboName] & Me![ComboName].
>>>
>>> I did try your expression and I'm not getting the correct result.
>>>
>>> Any other ideas?
>>>
>>> Norm[/color]
>>
>> You're correct. I did misread your request, and thought you wanted to
>> add text to a control,(a common procedure) based upon selections in
>> the combo box.
>>
>> It seems like a rather strange request and makes no sense to me.
>> You already have a at least one value in the combo (let's say "Joe)
>> that you select, and you want to change the value in the combo to
>> "JoeJoe"?
>> And then what? "JoeJoeJoeJoe".
>> The usual purpose of a combo is to select a value and insert into a
>> control or field not into itself.
>>[/color]
>
> Yes, that is exactly what I want to do. The reason is that the user
> is selecting multiple items from the combo, and all of their
> selections need to be captured in this string. I don't have the space
> to use checkboxes or radio buttons to select these items, and have
> many combos on the form. By selecting multiple items in the combo and
> concatenating them into one string, the user can assemble whatever
> string they desire into the combo. Unfortunately, I believe this is
> really the way I need to do it.
>
> Any ideas on how?
>
> Norm[/color]
Fred,
Based on your original suggestion to me, I think I solved the problem.
Thanks for taking the time to reply which enabled me to discover the
solution! Norm
| | | | re: How to accumulate text in a combobox?
Try this on the after update.
Me.YourField = Me.YourField & Me.ComboBox
Norm <odin231@comcast.net> wrote in message news:<Xns956A5AAAC530Dodin231comcastnet@216.196.97 .136>...[color=blue]
> Norm <odin231@comcast.net> wrote in
> news:Xns956A1F11EC68odin231comcastnet@216.196.97.1 36:
>[color=green]
> > fredg <fgutkind@example.invalid> wrote in
> > news:16w7fwa0tzrjr$.ol6rwz7c5ug6.dlg@40tude.net:
> >[color=darkred]
> >> On Sun, 19 Sep 2004 20:45:10 -0500, Norm wrote:
> >>
> >>> fredg <fgutkind@example.invalid> wrote in
> >>> news:1cd9436v0yz9v.6feh64v5juqb$.dlg@40tude.net:
> >>>
> >>>> On Sun, 19 Sep 2004 17:26:05 -0500, Norm wrote:
> >>>>
> >>>>> fredg <fgutkind@example.invalid> wrote in
> >>>>> news:1frgmpkizyzoq.ten75vexc8mb.dlg@40tude.net:
> >>>>>
> >>>>>> On Sun, 19 Sep 2004 16:22:11 -0500, Norm wrote:
> >>>>>>
> >>>>>>> Hi,
> >>>>>>>
> >>>>>>> Each time the user selects an item from a combobox, I want that
> >>>>>>> string to get appended to the values that were already selected.
> >>>>>>> The result is that the combo is accumulating text each time the
> >>>>>>> user selects an item from its list. I want the delete and
> >>>>>>> backspace keys to function normally, as well as all the other
> >>>>>>> properties of the combobox.
> >>>>>>>
> >>>>>>> Does anybody know the easiest way to do this?
> >>>>>>>
> >>>>>>> Thanks!
> >>>>>>> Norm
> >>>>>>
> >>>>>> Code the Combo Box AfterUpdate event:
> >>>>>> [ControlName] = [ControlName] & Me![ComboName]
> >>>>>
> >>>>> Hi Fred,
> >>>>>
> >>>>> Thanks for the reply, but that's not quite right. [ControlName]
> >>>>> and Me! [ComboName] both contain the new value selected by the
> >>>>> user. The result is that the old value gets lost and the combo
> >>>>> becomes equal to the new value string & the new value string.
> >>>>>
> >>>>> Norm
> >>>>
> >>>> You are not correct in your statement.
> >>>>
> >>>> Perhaps you should try it first, or perhaps you tried it but you
> >>>> did not write the expression properly.
> >>>> [ControlName] = [ControlName] & Me![ComboName]
> >>>> If you select 3 items, one at a time, from a combo box, the result
> >>>> in the text box will be the 3 items, one after the other.
> >>>> Select Yes, then Maybe, then No, and the text box will read
> >>>> YesMaybeNo.
> >>>>
> >>>> If you incorrectly wrote:
> >>>> [ControlName] = Me!ComboName
> >>>> then you would see only the last item selected.
> >>>>
> >>>
> >>> Thanks again for your reply.
> >>>
> >>> I think the problem is that I didn't fully explain what I'm trying
> >>> to do. I want to update the selected text in the combo with the
> >>> accumulated values. So...[ControlName] = [ComboName]. Using your
> >>> expression, it would be [ComboName] = [ComboName] & Me![ComboName].
> >>>
> >>> I did try your expression and I'm not getting the correct result.
> >>>
> >>> Any other ideas?
> >>>
> >>> Norm
> >>
> >> You're correct. I did misread your request, and thought you wanted to
> >> add text to a control,(a common procedure) based upon selections in
> >> the combo box.
> >>
> >> It seems like a rather strange request and makes no sense to me.
> >> You already have a at least one value in the combo (let's say "Joe)
> >> that you select, and you want to change the value in the combo to
> >> "JoeJoe"?
> >> And then what? "JoeJoeJoeJoe".
> >> The usual purpose of a combo is to select a value and insert into a
> >> control or field not into itself.
> >>[/color]
> >
> > Yes, that is exactly what I want to do. The reason is that the user
> > is selecting multiple items from the combo, and all of their
> > selections need to be captured in this string. I don't have the space
> > to use checkboxes or radio buttons to select these items, and have
> > many combos on the form. By selecting multiple items in the combo and
> > concatenating them into one string, the user can assemble whatever
> > string they desire into the combo. Unfortunately, I believe this is
> > really the way I need to do it.
> >
> > Any ideas on how?
> >
> > Norm[/color]
>
> Fred,
>
> Based on your original suggestion to me, I think I solved the problem.
> Thanks for taking the time to reply which enabled me to discover the
> solution! Norm[/color]
| | | | re: How to accumulate text in a combobox?
sloanw@sbcglobal.net (Wes) wrote in
news:3e5e3d7a.0409201202.437d1a77@posting.google.c om:
[color=blue]
> Try this on the after update.
>
> Me.YourField = Me.YourField & Me.ComboBox
>
>[/color]
Since I am updating the combo itself, your expression would become:
Me.ComboBox = Me.ComboBox & Me.ComboBox
Am I understanding you correctly? That expression would not produce the
correct result.
Norm | | | | re: How to accumulate text in a combobox?
"Norm" <odin231@comcast.net> wrote in message
news:Xns956ABDD3CD924odin231comcastnet@216.196.97. 136...[color=blue]
> sloanw@sbcglobal.net (Wes) wrote in
> news:3e5e3d7a.0409201202.437d1a77@posting.google.c om:
>[color=green]
>> Try this on the after update.
>>
>> Me.YourField = Me.YourField & Me.ComboBox
>>
>>[/color]
>
> Since I am updating the combo itself, your expression would become:
>
> Me.ComboBox = Me.ComboBox & Me.ComboBox
>
> Am I understanding you correctly? That expression would not produce the
> correct result.[/color]
I fairly sure you'll have to use a separate control to accumulate the results.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com | | | | re: How to accumulate text in a combobox?
Why not save yourself a whole lot of hassle and just use a
multi-select listbox? Comboboxes really are not built to do what you
want. MSLB's are.
| | | | re: How to accumulate text in a combobox?
pietlinden@hotmail.com (Pieter Linden) wrote in
news:bf31e41b.0409201812.10b466ae@posting.google.c om:
[color=blue]
> Why not save yourself a whole lot of hassle and just use a
> multi-select listbox? Comboboxes really are not built to do what you
> want. MSLB's are.[/color]
Great suggestion, however I have specific requirements which make the MSLB
not ideal. Each Combo/Listbox (there are over a dozen on each form) can
only be 2 characters in height to fit them all on the page and obviously
have a limited width. Scrolling through a listbox of 2 character height
only enables the user to see 1 item per line. It's much nicer with the
combo when they drop it down they can see all the choices but the control
still only takes up 2 lines in height.
Given the short height of the box, the look and feel is just better with a
Combo. Thanks for the idea though.
Norm | | | | re: How to accumulate text in a combobox?
Ravichandran J.V. <jvravichandran@yahoo.com> wrote in news:414ff977$0$26101
$c397aba@news.newsgroups.ws:
[color=blue]
> Have you tried
>
> comboBox1.Text&=comboBox1.SelectedItem.ToString()
>
> ?
>
>
> with regards,
>
>
> J.V.Ravichandran
> - http://www.geocities.com/
> jvravichandran[/color]
I tried that expression but there were multiple errors and it didn't
execute. Thanks for the try.
Norm |  |
Similar Microsoft Access / VBA bytes | | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,272 network members.
|
