Understanding List Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am struggling to understand how these are supposed to work. I have a field
that can have one of six values. In the table, I define the field as a text
field, the lookup as a list box with the row source type as as a value list
and a list of values separated by semicolons as the row source. Access97
accepts this field definition, but it is not recognized in forms that I
create. I thought I could simply place a list box on a form and bind it to
the field - but it doesn't work.

What am I missing? I don't have to create a separate table for these 6
values do I?

Lloyd
 
No you don't need a separte table! Open your form in design view and select
the listbox. Open properties to the Data tab. 1. Is the Row Source Type set
to Value List?
2. In the Row Source, are the six values listed there separated by
semi-colons?
3. Is the bound column set to 1?
Go to the Format tab ---
4. Is Column Count set to 1?
5. Is Column Width set to a numer of inches to display your list?
Close properties ---
6. Is the listbox drawn big enough to display several rows?
 
Back
Top