How do I edit the data I typed in a look up column in MS access?

[Guest]

I have input a look up column in my Microsoft Access database and I mis spelt
a word. Can anyone tell me how to edit the look up column to correct my
error. Thanks. Joan.

 

[John Vinson]

I have input a look up column in my Microsoft Access database and I mis spelt
a word. Can anyone tell me how to edit the look up column to correct my
error. Thanks. Joan.

This is one of many many reasons that most developers intensely
dislike "Lookup" fields. See

http://www.mvps.org/access/lookupfields.html

for a critique.

The Combo Box (to use its proper name) in your table may be based on
another table (the "lookup table") or on a list of values that you
typed in yourself. If it's a table, just edit that table. If it's a
list of values you may need to delete the lookup entirely and reenter
it - or, much better, create a new lookup table yourself. You can then
change your table lookup field to Textbox and create a Form for use in
editing your data; put a combo box on the form based on the lookup
table. It is not necessary to use the "lookup wizard" to do this!