By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

Spell Check Combo Boxes

P: 12
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.

Expand|Select|Wrap|Line Numbers
  1. Private Sub Command18864_Click()
  2.  
  3. RunCommand acCmdSelectRecord
  4. RunCommand acCmdSpelling
  5.  
  6. End Sub
  7.  
  8.  
Is there a way to force spell check to do the combo boxes?

Thank you
Jan 18 '10 #1
Share this Question
Share on Google+
4 Replies


nico5038
Expert 2.5K+
P: 3,072
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)
Jan 18 '10 #2

ADezii
Expert 5K+
P: 8,634
  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.
Jan 18 '10 #3

P: 12
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.
Jan 19 '10 #4

nico5038
Expert 2.5K+
P: 3,072
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)
Jan 19 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.