Solved

ms access 2007 multivalue field

Posted on 2011-09-14
5
443 Views
Last Modified: 2013-11-28
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.
0
Comment
Question by:howcheat
5 Comments
 
LVL 21
ID: 36538356
Yep. That is why I would recommend  NOT using this option.   I can't allow myself to call it a feature. Maybe a bug.

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

0
 
LVL 30

Expert Comment

by:hnasr
ID: 36546405
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.
0
 
LVL 30

Accepted Solution

by:
hnasr earned 500 total points
ID: 36546407
To edit the field you need to use the list of checkboxes.
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 36551201
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
0
 

Author Closing Comment

by:howcheat
ID: 36552157
Great!!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now