howcheat
asked on
ms access 2007 multivalue field
My multivalue checkbox works great on my form. However, it creates multiple records. One for each checked item. I only want my table and form to display a single with the multivalues separated by a comma. It looks like that until I save and then multiple records appear for each value.
The table displays the list of values.
Query displays list of va;ues if you select the fieldname, not fieldname.value.
Form displays a list of checboxes.
To display a list of values, create a textbox and set control source as fieldname.
Query displays list of va;ues if you select the fieldname, not fieldname.value.
Form displays a list of checboxes.
To display a list of values, create a textbox and set control source as fieldname.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I agree with the first poster. But if you do want (or need, say for SharePoint compatibility) to use multi-valued fields, see my Access Archon article on them:
http://www.helenfeddema.com/Files/accarch159.zip
http://www.helenfeddema.com/Files/accarch159.zip
ASKER
Great!!
On paper it sounds like it could be great. Once you starting trying to use it in production it becomes a nightmare.
Boyd Trimmell aka HiTechCoach
Microsoft MVP - Access Expert