Correction

  • Thread starter Thread starter Reen
  • Start date Start date
It depends on the source of the drop down box values.

If the source is a table or query, you need to edit the record in the table.

If the source is a list, you need to open the form in design view, click on
the combobox, and edit the string in the row source.

BE careful, if your combobox is bound to a field, you may suddenly have data
disappear from view. The misspelled value has been stored in a field in a
table and is no longer available as a choice in the combobox, so the combobox
may not show the misspelled value.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
A lot depends on where the drop down box is (table, query, or form). Then
there's the source for the dropdown combo box.

If a table or a query based on the table, open the table in design view.
Click on the field in question. Go down towards the lower left where you
should see General and Lookup tabs. Select the Lookup tab. You should see the
Row Source Type and Row Source. This will tell you where the misspelled word
is. You might just be able to change it there.

If on a form, open it in design view and click on the combo box in question.
Bring up its properties then go to the Data tab. The Row Source Type and Row
Source are there.
 
Back
Top