Value List In A Form

[grwilbourn]

I've created a form and have 3 fields that use value lists for input. I can
remember when I've made other databases that when entering data, as I start
to type an entry in the field, the associated item in the list would display.
It is not in this form.
What am I doing wrong or is that feature not available any longer. It sure
speeds up data input.
Thanks for you assistance.
I'm using MS OFC 2K

 

[John W. Vinson]

I've created a form and have 3 fields that use value lists for input. I can
remember when I've made other databases that when entering data, as I start
to type an entry in the field, the associated item in the list would display.
It is not in this form.
What am I doing wrong or is that feature not available any longer. It sure
speeds up data input.
Thanks for you assistance.
I'm using MS OFC 2K

A Combo Box control (used on a Form, typically) has an Auto Complete property;
by default it is Yes, and the control will do as you describe.

There are no "fields" on a form - there are Controls which can be bound to
fields in your table. What kind of control are you using? Combo Boxes have
been autocomplete since Access 1.0 and through 2007 (about four versions prior
and since your version).

 

[grwilbourn]

Thanks John, I used a poor choice of words. I understand the association of
the table and its fields to the controls on the form...
In the table I use List Box|Value List and typed in the Row Source. An
example, one of the fields in the table is Manufacturer and my Row Source has
in it: Compaq;Dell;Gateway;HP;Lexmark.
If I understand you correctly if I change from a List Box to a Combo Box
I'll get the Auto Complete property... I'll work on that and let you know how
it does.
I greatly appreciate your assistance - Thanks!!!

 

[grwilbourn]

John, I went in and change the the field in the table to Control Box using a
value list and the same row source. I then deleted the old control in the
form and inserted the Control Box control and it is doing exactly what I want
and needed. Thanks for your professional assistance, you have saved me hours
over time...
Thanks again....

 

[John W. Vinson]

John, I went in and change the the field in the table to Control Box using a
value list and the same row source. I then deleted the old control in the
form and inserted the Control Box control and it is doing exactly what I want
and needed.

I'd really suggest taking the next step and creating a table to store these
values. Value lists (for either combo or list boxes) are useful if the list of
values is very short and totally static: e.g. "M";"F" or the like. Your list
will someday need additions or changes, and that's much easier with a table
than with a value list!

 

[grwilbourn]

Sorry for the delay in replying, been on the road the last couple of days. I
will take your advise and create tables for these three values. Thanks again
for all your help...