Re: Dropdown List

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks --- I already have the "limit to list" property set --- that's what's
giving the current error message. But I never thought of turning off
autoexpand and using a keyup event! That sound like something cool to try
out! Bob.

"freakazeud" <freakazeud@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FA633197-34B9-4E4B-BE79-12C69A468CC0@xxxxxxxxxxxxxxxx
> Hi,
> A combobox will always allow a user to type data in it.
> You can set the limit to list property so they can just type values which
> are in the list. Additionally you can turn of autoexpand so values do not
> come up when typing. If you really want to eliminate the typing then add
some
> code on the keyup event of the combobox:
>
> MsgBox("Can't type here!")
> Me.YourCombo = null
>
> HTH
> Good luck
>
> --
> Oliver
> Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
> http://www.oli-s.de
>
>
> "Martureo Bob" wrote:
>
> > Sorry if this it a duplicate post --- I cannot find the original or any
> > responses....
> >
> > Using A2K, I want to create a simple unbound dropdown list on a form
giving
> > the user specific choices, and requiring the selection of one of the
> > pre-determined choices.
> >
> > I set the property to only permit the user to select items on the list,
but
> > Access still allows the user to type into the control --- and get an
error
> > message back if the result is not in the list.
> >
> > It's just that this dosn't seem very "professional." If I'm requiring a
> > choice from a predetermined set of values, how can I set things up so
that
> > the only thing the user can do is highlight an entry and click it (but
not
> > type into it the control and possibly get an error).
> >
> > BTW, I don't have enough room for a listbox.
> >
> > Thanks!
> >
> > Bob.
> >
> >
> >


.

Relevant Pages

  • Re: 2 column drop down lists
    ... Thanks Bob for the code - I've printed it out so as to review ... > Hi Jim, ... > If you want to pick up multiple columns from the combobox, ... > Private Sub ComboBox1_Click ...
    (microsoft.public.excel.misc)
  • Re: Height of Combobox
    ... > Hi Bob, ... There are other Combobox ... >> I have an MSFlexGrid and the user inputs data into the grid through a ... When the user click on any cell, ...
    (microsoft.public.vb.controls)
  • Re: Height of Combobox
    ... > Hi Bob, ... There are other Combobox ... >> I have an MSFlexGrid and the user inputs data into the grid through a ... When the user click on any cell, ...
    (microsoft.public.vb.controls)
  • Combobox autoexpand erratic behaviour
    ... Recently I've encountered a problem with Autoexpand ... Autoexpand in a combobox in the same application ... fills the text fine but suddenly, after typing another letter the text from ...
    (microsoft.public.access.forms)
  • Re: how to make forms combo box jump to to of list
    ... You've used a combobox from the Forms Toolbar. ... What Bob is describing, ... and the behaviour that you want, is in a combobox from the Control Toolbox. ...
    (microsoft.public.excel.misc)