The next comment will state my opinion on whether or not you should use multi-valued fields in your tables...

They're horrible. Do not use them. They were added in there to give beginner users a "cheat" for storing lists to select from when in reality you should be using Relationships and Relational Combo Boxes.

It's funny you asked this because someone else just asked me this same question a few days ago. I added it to the TechHelp list. I'm going to be putting together a PROPER video explaining why you should never use these. Stay tuned.

Thank you, i figured they were a bad option but didnt really know so again, thank you for that

That's the problem. People don't know. They see this cool feature in Access and decide it's a good idea. It's not. I don't like that Microsoft added it. I see where they were going with that. It's a handy feature for someone who doesn't plan on being a developer and doesn't care about learning THE CORRECT WAY to build a database. You need to pick from a list of options? Sure. Use a multi-valued field. You need to store a resume in an employee's record? Sure use an attachment. Don't blame us that your ACCDB file just tripled in size! If you have any desire to be a REAL developer and learn Access the RIGHT way these are features to avoid. I didn't emphasize this enough when I recorded my Access 2013 classes and these features were still new. I've learned a lot myself over the last 8 years. Now that I'm re-recording the Beginner series again, I'm making it clear: I'll show you how to use these things, but you shouldn't use them!

Thank you