If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Value List In A Form
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 |
#2
|
|||
|
|||
Value List In A Form
On Sat, 20 Sep 2008 18:40:00 -0700, grwilbourn
wrote: 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). -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Value List In A Form
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!!! "John W. Vinson" wrote: On Sat, 20 Sep 2008 18:40:00 -0700, grwilbourn wrote: 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). -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Value List In A Form
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.... "grwilbourn" wrote: 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!!! "John W. Vinson" wrote: On Sat, 20 Sep 2008 18:40:00 -0700, grwilbourn wrote: 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). -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Value List In A Form
On Sun, 21 Sep 2008 20:05:01 -0700, grwilbourn
wrote: 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! -- John W. Vinson [MVP] |
#6
|
|||
|
|||
Value List In A Form
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... "John W. Vinson" wrote: On Sun, 21 Sep 2008 20:05:01 -0700, grwilbourn wrote: 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! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|