Access 2007: Multiselect List box, change input mask based on # of selections
Posted on 2011-02-18
Hello, I am curious if the following procedure would work in Access 2007. I have a multi-select list box with several items. The entries from this box are passed along to a field, and then I have another field describing these selections in the form of a %. I would like to have consistent looking data so I want to apply an input mask to this field based on the number of selections the user has made in the multi-select box. For example, the user has made 3 selections so the input mask would be something like 00%, 00%, 00% and changed based on how many values the user has selected. Does anyone know how to code this? Bonus points if you can make it such that Multiselect choice1 00%, Mutliselect choice2 00%, etc...