Multi Select List Box

[jdulac]

Ok all I'm looking for is a simple step by step on setting up a multiselct list box in Access 2003. I can't beleive this isn't a built in option or am I missing something? Its a simple text field with a list of different states but I have to be able to choose more than one state per employee. TIA.

 

[mhartman1]

Hello:

Merely drop your list box on your form and in the properties section for Multi select, pick, None, Simple, or Extended.

Regards
Mark

 

[jdulac]

Thanks. I haven't worked in Access in soo long. Now how do I report on this. I quickly just ran a report and it list the whole list on each field.

 

[jdulac]

It looks like I am having problems selecting the values for this field. I highlight the values for a particular record I want but if I go back to that record the fields are no longer highlighted. Is there something else I have to do to select the values or is there something else I need to set in the Properties?

 

[lespaul]

check out FAQ701-4693 and FAQ701-4432

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi