Spell Check Correction Case Correction Code Question

[Dave Elliott]

How can I make the below change to McDonalds after spell check?
Customer = StrConv(Customer, vbProperCase) is the code on after update
There is no mask for the control. Control name is Customers
Mcdonalds

 

[Allen Browne]

One approach is to create a table of exceptions.
The code will DLookup() the table.
If found, use the returned value.
If not found, use thte StrConv() value.