[AccessD] combo box 101

Arthur Fuller fuller.artful at gmail.com
Mon Aug 8 22:11:32 CDT 2011


Something else that you may wish to consider is this idea: rather than
simply including all the columns, create a query that concatenates several;
for example, City and State, so the list shows "Toronto, ON" and "Toronto,
CA" as separate rows, or another example could be "Surname & ", " and
GivenName. In my experience this is often more effective and efficient than
attempting to present all the columns.

Incidentally, I also have some code that enables the tab key to jump to the
next word in a list, so that similar things like names can easily be
navigated, for example, "Wilson, Beverly" and "Wilson, Charles". If you want
it I'll post it.

A.

On Mon, Aug 8, 2011 at 10:10 PM, William Benson (VBACreations.Com) <
vbacreations at gmail.com> wrote:

> I appreciate the suggestion.
>
> A little late for now, but I will consider it heavily in future work.
>
> Thanks Arthur.
>
>



More information about the AccessD mailing list