Re: Move to index in combo box
- From: "Jeff Boyce" <nonsense@xxxxxxxxxxxx>
- Date: Thu, 2 Feb 2006 12:32:45 -0800
Banaticus
The combo box has a property you can set that will "auto-complete" when you
begin typing. No need to set up additional controls (i.e., boxes) to filter
the combo box.
Open the properties of the combo box in design mode and look for
"AutoExpand". Check Access HELP for more information on this property.
Regards
Jeff Boyce
<Office/Access MVP>
"Banaticus" <Banaticus@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DAAEB3DA-E94F-4F7D-877E-15BA34C25CF0@xxxxxxxxxxxxxxxx
I've been using a combo box to jump to a specific record in a form. But,
even with the comb box set at 15 lines long, with many hundreds of records
in
the form the vertical slider on the combo box is a little small and can be
jumpy (moving 1/32" jumps 10 names, etc.). The combo box is formed from:
SELECT [cust num], [last name], [first name]
FROM [this table]
ORDER BY [last name], [first name];
I'd like to put in some boxes that will jump the combo box to a certain
set
of names. For instance, put in a box with a label on it that says "M".
Pressing this button would jump the combo box to the first [last name]
that
starts with the letter M. For instance, if I have records for:
Lupold
Macaroni
Martin
Then it would jump to Macaroni. But, if Macaroni is deleted, then Martin
would be the first name that begins with M and pressing the "M" box should
jump the combo box to Martin.
.
- Prev by Date: Re: Command button to open 'Filter by Form' window
- Next by Date: Re: ComboBox and DLookup Issue
- Previous by thread: Re: Command button to open 'Filter by Form' window
- Next by thread: Re: Move to index in combo box
- Index(es):
Relevant Pages
|
