How To Change The Access Table Field Lookup > Allow Multiple Values From YES to NO. In the records, all multiple values have been eliminated and only a single value now exist. However, Access still does not allow one to change the setting from YES to NO. Please Advise - I Appreciate Your Help THANKS
Scott Axton
@Reply 3 years ago
Irf you are referring to a Multivalued Field those are generally not recommended. In fact they are on Richard's Evil Access Stuff list. See: Multivalued
A better solution would be to use a relational table. See the Multiple YN video.
Kevin Yip
@Reply 3 years ago
You can't change a multivalue field back to a single value field. That's one of a long list of caveats about MVF that make people not want to use them. To change it to a single-value field, first, use the MVF's "Value" property in a query:
SELECT ID, YourMVFName.Value FROM Table1
The result will be a list of single-value fields. Then you can use an action query to transfer the content to a NEW, single-value field in the table. Then remove the old MVF.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
