Created a multi-value field on accident; can't identify it

[templeowls]

I am trying to append a table into another, but I cannot because I have a multi-valued field. I must have created this by mistake as I do not have a need for a multi-valued field. Is there a way to identify which field is multivalued and change it back to single-value?

[ranman256]

look at the table design, the field type will be: ATTACHMENT

[ssanfu]

Once you find the fields that are combo boxes, change to table design view.



Then click on the field name and look at the tabs at the bottom.

1) Click on the "Look up" tab.
2) You should see "Combo box" or "List box" in the Display Control property line.
3) Change the "Allow Multiple Values" property from YES to NO.

4) I would also recommend changing the Display Control property (#2 above) to "TEXT BOX". You should NEVER use a "Look up field" or "Multi-Value Field" in tables!


------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------

EDIT: On my computer I just ran across some code by Daniel Pineault to help identify all the table fields that are set as a Lookup. Rather than post the code or text file, I located the site (changed from the text file)

https://www.devhut.net/2017/05/26/ms...lookup-fields/


Might as well throw in:
MS Access – VBA – Reset the Table Lookup Display Control Property to Text Box

[isladogs]

Attachment fields are just one type of MVF. All MVFs are a bad idea
For an extended article explaining about multivalued fields in detail, see http://www.mendipdatasystems.co.uk/m...lds/4594468763