Re: Combo box with large table as source

Tech-Archive recommends: Speed Up your PC by fixing your registry

John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:soj5c5lqd6jlg9ia6blg319fcvoh1mfgnm@xxxxxxx:

On 30 Sep 2009 02:15:22 GMT, "David W. Fenton"
<XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote:

John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:7255c51tpcfea9h2dtp8agc866tmagh8on@xxxxxxx:

A combo is limited to 65536 entries - which is at least a
hundred times too many for a user to scroll or even autocomplete
through.

100? I'd say it's 5,000 too many!

Erm? So you wouldn't use a 14-row combo box because 13 is too
many?

Ack, decimal point error! I should have said 500.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Combo box with large table as source
    ... many for a user to scroll or even autocomplete through. ... John W. Vinson [MVP] ...
    (microsoft.public.access.modulesdaovba)
  • Re: Combo box with large table as source
    ... John W. Vinson wrote in ... times too many for a user to scroll or even autocomplete through. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (microsoft.public.access.modulesdaovba)
  • Re: Combining Fields
    ... They shouldn't need to scroll AT ALL. ... if "very long" means over 65536 rows but that's a whole nother can of worms. ... John W. Vinson [MVP] ...
    (microsoft.public.access.queries)
  • Creating many forms from one table - Newbie - John W. Vinson
    ... John W. Vinson wrote: ... Creating many forms from one table - Newbie ... A good spreadsheet design is often a very bad table design. ...
    (microsoft.public.access.forms)
  • Re: Q: changing Table in form
    ... "John W. Vinson" wrote: ... because it opens up another window. ... that they pull from a system, create an Excel spreadsheet and email to ...
    (microsoft.public.access.modulesdaovba)