quick query result question

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

Ginger

Sorry to post to the general group, but I can't get the
folder list to scroll down to queries in ACCESS.

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
 
First check that the combo's auto-correct is disabled.

Open the form in design view.
Right-click the combo, and choose Properties.
On the "Other" tab, make sure Allow AutoCorrect is No.
 
Hi Ginger,

Although I cannot reproduce your observation at the moment, try setting the Allow Autocorrect
property for the combo box to No. In form design view, click on View > Properties to bring up
the properties dialog. Then select the combo box. You should see the name of the combo box in
the blue title bar of the properties dialog. Select the Other tab. The Allow Autocorrect
property is the sixth one from the top of the list. Set it to No. Also, when viewing your form,
click on Tools > Autocorrect Options... You might find "yar" in the replace list.
....and tell me if I'm correct in assuming that I need to code a "if not found" sub?
Click to expand...
You can use the Not in List event procedure to respond to situations where an item is not in the
list, if you wish to add this item to your database. If you are simply using your combo box to
look for existing data, then you won't need to code for this situation. You can download an
example of using the Not in List event procedure from:

http://www.eade.com/AccessSIG/downloads.htm
(demo mdb and Word files 608 kb)

Tom
_____________________________________


Sorry to post to the general group, but I can't get the
folder list to scroll down to queries in ACCESS.

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
 
Tom, Thanks! it worked! and yes, YAR was in the autocorrect
list.

Ginger
-----Original Message-----
Hi Ginger,

Although I cannot reproduce your observation at the
Click to expand...
moment, try setting the Allow Autocorrect
property for the combo box to No. In form design view,
Click to expand...
click on View > Properties to bring up
the properties dialog. Then select the combo box. You
Click to expand...
should see the name of the combo box in
the blue title bar of the properties dialog. Select the
Click to expand...
Other tab. The Allow Autocorrect
property is the sixth one from the top of the list. Set
Click to expand...
it to No. Also, when viewing your form,
click on Tools > Autocorrect Options... You might find "yar" in the replace list.
to code a "if not found" sub?
You can use the Not in List event procedure to respond to
Click to expand...
situations where an item is not in the
list, if you wish to add this item to your database. If
Click to expand...
you are simply using your combo box to
look for existing data, then you won't need to code for
Click to expand...
this situation. You can download an
 
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.
Click to expand...

Select Tools... Options... Spelling, and click on the "AutoCorrect
Options" button. Uncheck the "Replace Text as you Type" option; it's
almost always more trouble than it's worth in Access!
 
Back
Top