Check boxes

[sagsh]

I have about 20 check boxes on a form for various preference indicators a user can select - is there a way I can add these check boxes to something like a text box field with a vertical scroll bar so that I can reduce the amount of space these check boxes take up on my form?

Thanks for any help

Sags

 

[Pat Hartman]

Your data is not normalized. If you normalize it, you can use a subform that you can size to suit.

Make a tblPreferences where preferences will be stored in one row per preference. and tblPreferenceType where the preferences are identified. tblPreferences is a relation table that links a person to his preferences.

tblPreferences
PersonID (primary key fld1, foreign key to person table)
PreferenceTypeID (primary key fld2, foreign key to preference type table)

tblPreferenceType
PreferenceTypeID (autonumber primary key)
PreferenceName

If you need help understanding how a many-to-many relationship works, download my many-to-many