Limit Number of Selections in a Multiple Value List?

[Hey Lucy]

Is it possible (without using VB) to limit the number of selections a user can make in a multiple value list?

My list is one a form and when in the form field it brings up a total of 15 names with checkboxes, allowing you to "check" each name you want. However, I want to be able to have as many names as I need in the list, but limit the user to selecting only two of them.

Just wondered if there is a way.

Thanks!
Lucy

 

[CJ_London]

Not without using vba

 

[Hey Lucy]

Thanks CJ! Least I know not to beat this horse then....sigh :-( I've really got to learn VB...but I'm too busy with so many projects I can't get to it...a Catch 22...knowing VB would help with all my projects, but deadlines won't allow for time to learn. Oh well. Thanks for responding to me!

 

[CJ_London]

If you are an excel user - you can practice vba usage there - the overall principle is the same but references are to workbooks/worksheets/cells and ranges rather than fields and controls