access 2007 "allow multiple values" won't take No for an answer

I accidently set a field to "allow multiple values" and now Access will not
let me correct my error. Is there a way?

"Bob Arnett" wrote in message
...
I accidently set a field to "allow multiple values" and now Access
will not let me correct my error. Is there a way?

In table design view, add a new field, and delete the old one.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Well, in this case... this was a dbf with about 6,000 that I imported and
have since made quite a few changes to. So, how can I keep the values of that
field.

"Allen Browne" wrote:

"Bob Arnett" wrote in message
...
I accidently set a field to "allow multiple values" and now Access
will not let me correct my error. Is there a way?

In table design view, add a new field, and delete the old one.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Bob

One approach might be to first add the field Allen suggested, then run an
update query. Are you confident that there is only "one-per-record" in the
old field?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Bob Arnett" wrote in message
...
Well, in this case... this was a dbf with about 6,000 that I imported and
have since made quite a few changes to. So, how can I keep the values of
that
field.

"Allen Browne" wrote:

"Bob Arnett" wrote in message
...
I accidently set a field to "allow multiple values" and now Access
will not let me correct my error. Is there a way?

In table design view, add a new field, and delete the old one.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Thanks for the direction. There definitely was only one value per field since
I hadn't had enough time to mess it up. As it turned out, when I did a query
to get just the right fields I noticed there was a "sub-field" (I'm ignorant,
I admit). The field I had in my table was "Class" and there was a
"Class.value" underneath "Class" when I was selecting fields. So I included
that field in the query and then selected that column, copied it and then
pasted it into my new "Class2" field. Worked great. I also learned a bit more
about "multiple values".

"Jeff Boyce" wrote:

Bob

One approach might be to first add the field Allen suggested, then run an
update query. Are you confident that there is only "one-per-record" in the
old field?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Bob Arnett" wrote in message
...
Well, in this case... this was a dbf with about 6,000 that I imported and
have since made quite a few changes to. So, how can I keep the values of
that
field.

"Allen Browne" wrote:

"Bob Arnett" wrote in message
...
I accidently set a field to "allow multiple values" and now Access
will not let me correct my error. Is there a way?

In table design view, add a new field, and delete the old one.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.