WatchOut for "Allow AutoCorrect" in your unbound combobox lookups.
I am building a personnel database, and the last name of Ballance was
causing the following message to popup, prohibiting me from selecting
the record:
"The text you entered isn't an item in the list" dialog box
Went nuts trying to figure out the problem, and then discovered that
changing the combobox property "Allow AutoCorrect" as OFF corrected the
issue.
Greg
ApexData@gmail.com - 29 Dec 2006 21:17 GMT
Is there anyway to default the "Allow AutoCorrect" to False for the
entire database,
once you have begun coding??
This link gives a predevelopment solution:
http://www.access.qbuilt.com/html/vba5.html