Re: Combobox help

If you just want to use text for what you show, you can set the Row Source
Type to a Value List, then put text strings (separated by semicolons) as the
values to show.

Are you wanting to show the exact strings that you posted? What will you do
with the value that the user selects in the combo box?

--

Ken Snell
<MS ACCESS MVP>

"Sue Compelling" <SueCompelling@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4EEBD0ED-2289-48D5-9A6A-C52711058801@xxxxxxxxxxxxxxxx
> Hi Ken - I want ALL THREE options to display in the combobox as THREE
> separate lines, and then I want the user to select ONE of the three
> options .
> [The options are for 'declaring' WHO donated funds. ie - was it the
> couple
> [parents], or as individuals [in the case of separated parents]. This is
> a
> student fundraising db.
> --
> Sue Compelling
>
>
> "Ken Snell [MVP]" wrote:
>
>> It's not clear what you want here. Do you want all three options to show
>> as
>> values in each row? Or do you want to show the three "options" exactly as
>> you've posted (which I admit would not seem to make sense)? Or do you
>> want
>> the ability to let the user select which option to show? Or do you want a
>> single value to show that will not have "blank or extra spaces" if a
>> value
>> doesn't exist in one or more of the fields?
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>> "Sue Compelling" <SueCompelling@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> message
>> news:5290B019-BF6C-416B-A634-E854D4904397@xxxxxxxxxxxxxxxx
>> > Hi - really stuck on this one - a newbie and can 'do code' if
>> > everything
>> > is
>> > supplied.
>> >
>> > I want the following THREE options to be available from the combobox
>> > [and
>> > am
>> > assuming that it can be done]
>> >
>> > CG1FirstName & " " & CG1LastName & " & " & CG2FirstName & " " &
>> > CG2LastName
>> >
>> > or
>> >
>> > CG1FirstName & " " & CG1LastName
>> >
>> > or
>> >
>> > CG2FirstName & " " & CG2LastName
>> >
>> > TIA
>> > --
>> > Sue Compelling
>>
>>
>>


.

Relevant Pages

  • Re: Combobox help
    ... Hi Ken - I want ALL THREE options to display in the combobox as THREE ... separate lines, and then I want the user to select ONE of the three options. ... >> Sue Compelling ...
    (microsoft.public.access.forms)
  • Re: Populating a Combo Box with instances of a class - problem
    ... ComboBox does not know what to do with it except for calling its ToString ... DataSource property. ... > if you just added a bunch of strings to a combo box, ... > the combo box to display multiple entries, ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: ComboBox Item (Windows Forms)
    ... ComboBox Item separately from the Value, since Item is an Object, and ... your ComboBox to a list of strings, a list of objects, a dataset, etc. ... you bind it to a list of string, ... name/value pair class, and using that when adding items to a ComboBox. ...
    (microsoft.public.dotnet.general)
  • Re: AutoComplete ComboBox Search on Substring for KeyPress
    ... Smith) and would like to go to the LAST name whenever a user presses a key while on this combobox. ... I have an implementation that uses a text box and a hidden listbox. ... The search will return a list of strings and those strings will be bound to the listbox. ... Private Sub ArtistName_TextChanged'Handles ArtistName.TextChanged ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Symbols, metacircular evaluation, external representation.
    ... they treated as strings instead of a separate data type? ... a separate or more limited language to do your macros, ... I doubt that's all the application of external representations. ...
    (comp.lang.scheme)