Can't make a multivalued field



I am trying to create a multivalued field in the table of an existing
database. For some reason, when I do the lookup wizard, it doesn't ask me if
I want the allow multiple values. Also, the lookup properties of the fields
don't have the option to allow multiple values.

It isn't a problem with my computer or the Access 2007 that I am using
because if I open a new database it allows me to select the option that
allows for multiple values. Is there a setting that I need to change in my
existing database so that I can add a multivalued field?


How do I do this? (I'm new to using Access)

Chris O'C via said:
You need to convert the db to accdb format for multivalue fields. mdb format
can't store them.

Microsoft MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question