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

B

Bob Arnett

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

Allen Browne

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

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

Bob Arnett

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.
 
J

Jeff Boyce

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
 
B

Bob Arnett

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".
 
Top