text automatically changes

  • Thread starter Thread starter Ginger
  • Start date Start date
G

Ginger

My apoligies, I also posted in the General discussion,
couldn't get the screen to scroll down to queries.

Here's the scenario and question...I have a patient
database I inherited that has a combo drop down list to
select patients with no discharge date.
When typing "Yar" in the drop down combo, it does not find
that patient, which is ok because the patient does have a
discharge date, but in the combo box, it changes the "Yar"
to be "year" and then tells me it is not found.

I've never seen it auto correct, if not found.

Can you possibly know of any reason for this and tell me if
I'm correct in assuming that I need to code a "if not
found" sub?

Thank you in advance,
Ginger
..
 
Set the Allow Auto Correct property of the combo box control to NO.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Open the form in design view, choose the combo and open its properties. Go
to the Other tab and change Allow Autocorrect to No.
 
Back
Top