Understanding List Boxes

L

Lloyd

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
 
P

PC Datasheet

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top