Is there any way of displaying multiple choice answers other than tick boxes?

[jam]

As above really. I'm trying to create a form to store requirements. The answers are either
A1, A2, A3, A4, A5, B1, B2, B8, C1, C2, C2A, C3, D1, D2, Sui Generis, High footfall, Shopping Centre, High Street, Neighbourhood Retail, Out of town, Near major road ect ect ect

The answers can be multiple for instance...
A3+A5+Shopping Centre+High Street+Near a major road

I don't really want to display a form with all these as check boxes. Is there any other way of displaying them so they can be selected in their multiples and stored?

 

[missinglinq]

You could use a ListBox control set to Multi-Select, but that's still going to require a lot of real estate, screen-wise. In Access 2007 the ComboBox control also has the Multi-Select option, I understand. In other versions you can use code to imitate this with a combobox.

But I have to warn you that storing multiple values in a single field is generally considered to be very poor design! It should only be done if you're absolutely, positively without a single doubt sure that you will never need to do any kind of data manipulation with this field! That means no searching, sorting or parsing back out to its individual components. If there's any possibility that you'll ever need to do any of this you need to rethink your problem.

The space problem on your form, for instance, could be solved by using a tabbed control, with all of these options on a separate page.