Spell Check Combo Boxes

[alnino]

Hi,

I currently have a form that uses combo boxes for user input. The combo boxes function as “autocomplete”. All works fine except for:

I have a command button to spell check the current form record. The spell check will not check any of the combo boxes.

Private Sub Command18864_Click()
 
RunCommand acCmdSelectRecord
RunCommand acCmdSpelling
 
End Sub
 
 

Is there a way to force spell check to do the combo boxes?

Thank you

[nico5038]

Just puzzled why you want to spellcheck a combobox.
The values should be checked before adding them to the table the combo is based on and typo's will show by not returning an autocomplete value.

Nic;o)

[ADezii]

1. Access will only Spell Check Text Box Controls Bound to Text or Memo Data Type Fields.
2. I have code that will:
   1. Using Automation, Open an Instance of Microsoft Word.
   2. Create a New Word Document,
   3. Paste the supplied Text passed to a Function to this Document.
   4. Check the Text for spelling, using Word's Dialogs.
   5. Once finished, the Function returns the corrected Text to wherever you would like it.
3. If you are interest, just let me know and I'll post it.
4. Like Nico, I'm also puzzled why you would want to do such a thing, unless possibly Limit To List = No.

[alnino]

Nico,

When the user enters data in the combobox, it may be new data, therefore there is no “autocomplete” record for it to reference.

There are around 1000 records, each record is a unique project, but there are multiple records that may have the same “contact” information, or it may be new information.

I have only changed these text boxes to combos for user convenience.

I thought that there may be a way to spell check the associated table fields for the comboboxes, from the form.

Oh well, I didn’t really think that it was possible.

ADezii, thank you for the offer, but the users won’t want to go thru the process.

[nico5038]

My solution would be to offer a new form to enter a new combo value and have them (or the code) spell check the data before saving it.

The combo will always hold checked data this way.

Nic;o)