For some reason Microsoft decided to limit combo boxes
and list boxes which severely limits my search
functionality if it wont return more record.

I understand this to exist in Access 97 and 2000.

Does anyone know if this problem still exists in later
versions of Access?

If it doesn't then I will have to upgrade.

Thanks
Kelly

"Kelly" <(E-Mail Removed)> wrote in message
news:116001c3887c$75c84fd0$(E-Mail Removed)...
>
> For some reason Microsoft decided to limit combo boxes
> and list boxes which severely limits my search
> functionality if it wont return more record.
>
> I understand this to exist in Access 97 and 2000.
>
> Does anyone know if this problem still exists in later
> versions of Access?
>
> If it doesn't then I will have to upgrade.

AFAIK it is still the same. People don't usually like scrolling through huge
lists anyway. A common method is to provide a TextBox where the user provides a
few starting characters so that the displayed list can be narrowed
significantly.




--
*******************************
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
*******************************

"Rick Brandt" <(E-Mail Removed)> wrote in message
news:blg06b$c0pp1$(E-Mail Removed)...
> "Kelly" <(E-Mail Removed)> wrote in message
> news:116001c3887c$75c84fd0$(E-Mail Removed)...
> >
> > For some reason Microsoft decided to limit combo boxes
> > and list boxes which severely limits my search
> > functionality if it wont return more record.
> >
> > I understand this to exist in Access 97 and 2000.
> >
> > Does anyone know if this problem still exists in later
> > versions of Access?
> >
> > If it doesn't then I will have to upgrade.
>
> AFAIK it is still the same. People don't usually like scrolling through
huge
> lists anyway. A common method is to provide a TextBox where the user
provides a
> few starting characters so that the displayed list can be narrowed
> significantly.

In addition to Rick's comments, take a look at what Allen Browne has at
http://users.bigpond.net.au/abrowne1/ser-32.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele