Hey all I have a spelling error in my lookup column. So I would like to change the spelling and have it automatically correct the spelling on all the records with the misspelled value. I am using Access 2007. Suggestions anybody!!

Use an update query to update to the correct spelling, criteria would be the wrongly spelled word.

thanks I got it spelled correctly and all the records updated to reflect the new spelling

Excellent, glad it worked!