Is there any way to have an Alphabetic lookup within a pick box? I have a
long list of data and it would help to have the list shorten up based on a
the spelling of the name.

If your data is sorted, then you could use the Combobox from the Control
Toolbox toolbar.

--
Regards,
Tom Ogilvy


"Mathew" wrote:

> Is there any way to have an Alphabetic lookup within a pick box? I have a
> long list of data and it would help to have the list shorten up based on a
> the spelling of the name.

Tom: I'm new at this could you help me a little more on comboboxs. I read
the help file but it didn't really help me!

"Tom Ogilvy" wrote:

> If your data is sorted, then you could use the Combobox from the Control
> Toolbox toolbar.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Mathew" wrote:
>
> > Is there any way to have an Alphabetic lookup within a pick box? I have a
> > long list of data and it would help to have the list shorten up based on a
> > the spelling of the name.

if it's sorted you can use one of the matchentry properties for the combobox:

select the cobobox and press F4.

look for matchentry

fmMatchEntryFirstLetter 0 Basic matching. The control searches for the
next entry that starts with the character entered. Repeatedly typing the same
letter cycles through all entries beginning with that letter.
FmMatchEntryComplete 1 Extended matching. As each character is typed, the
control searches for an entry matching all characters entered (default).
FmMatchEntryNone 2 No matching.


--


Gary


"Mathew" <(E-Mail Removed)> wrote in message
news:B3DD224A-704B-4733-B00A-(E-Mail Removed)...
> Tom: I'm new at this could you help me a little more on comboboxs. I read
> the help file but it didn't really help me!
>
> "Tom Ogilvy" wrote:
>
>> If your data is sorted, then you could use the Combobox from the Control
>> Toolbox toolbar.
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>> "Mathew" wrote:
>>
>> > Is there any way to have an Alphabetic lookup within a pick box? I have a
>> > long list of data and it would help to have the list shorten up based on a
>> > the spelling of the name.

Notice:

>FmMatchEntryComplete 1 Extended matching. As each character is typed, the
>control searches for an entry matching all characters entered (default).

says it is the default - This appears to be what the OP wanted so it should
require no additional action beyond assigning a sorted range of values in the
ListFillRange property.

--
Regards,
Tom Ogilvy


"Gary Keramidas" wrote:

> if it's sorted you can use one of the matchentry properties for the combobox:
>
> select the cobobox and press F4.
>
> look for matchentry
>
> fmMatchEntryFirstLetter 0 Basic matching. The control searches for the
> next entry that starts with the character entered. Repeatedly typing the same
> letter cycles through all entries beginning with that letter.
> FmMatchEntryComplete 1 Extended matching. As each character is typed, the
> control searches for an entry matching all characters entered (default).
> FmMatchEntryNone 2 No matching.
>
>
> --
>
>
> Gary
>
>
> "Mathew" <(E-Mail Removed)> wrote in message
> news:B3DD224A-704B-4733-B00A-(E-Mail Removed)...
> > Tom: I'm new at this could you help me a little more on comboboxs. I read
> > the help file but it didn't really help me!
> >
> > "Tom Ogilvy" wrote:
> >
> >> If your data is sorted, then you could use the Combobox from the Control
> >> Toolbox toolbar.
> >>
> >> --
> >> Regards,
> >> Tom Ogilvy
> >>
> >>
> >> "Mathew" wrote:
> >>
> >> > Is there any way to have an Alphabetic lookup within a pick box? I have a
> >> > long list of data and it would help to have the list shorten up based on a
> >> > the spelling of the name.
>
>
>

know that, but who knows what options have ever been changed, so i just pointed
out where the option was for his knowledge.

--


Gary


"Tom Ogilvy" <(E-Mail Removed)> wrote in message
news6FAF552-16E7-43EF-A194-(E-Mail Removed)...
> Notice:
>
>>FmMatchEntryComplete 1 Extended matching. As each character is typed, the
>>control searches for an entry matching all characters entered (default).
>
> says it is the default - This appears to be what the OP wanted so it should
> require no additional action beyond assigning a sorted range of values in the
> ListFillRange property.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Gary Keramidas" wrote:
>
>> if it's sorted you can use one of the matchentry properties for the combobox:
>>
>> select the cobobox and press F4.
>>
>> look for matchentry
>>
>> fmMatchEntryFirstLetter 0 Basic matching. The control searches for the
>> next entry that starts with the character entered. Repeatedly typing the same
>> letter cycles through all entries beginning with that letter.
>> FmMatchEntryComplete 1 Extended matching. As each character is typed,
>> the
>> control searches for an entry matching all characters entered (default).
>> FmMatchEntryNone 2 No matching.
>>
>>
>> --
>>
>>
>> Gary
>>
>>
>> "Mathew" <(E-Mail Removed)> wrote in message
>> news:B3DD224A-704B-4733-B00A-(E-Mail Removed)...
>> > Tom: I'm new at this could you help me a little more on comboboxs. I read
>> > the help file but it didn't really help me!
>> >
>> > "Tom Ogilvy" wrote:
>> >
>> >> If your data is sorted, then you could use the Combobox from the Control
>> >> Toolbox toolbar.
>> >>
>> >> --
>> >> Regards,
>> >> Tom Ogilvy
>> >>
>> >>
>> >> "Mathew" wrote:
>> >>
>> >> > Is there any way to have an Alphabetic lookup within a pick box? I have
>> >> > a
>> >> > long list of data and it would help to have the list shorten up based on
>> >> > a
>> >> > the spelling of the name.
>>
>>
>>