Spellchecker function that selects only the control you are using

[Ruegen]

I have a function that checks the spelling of the text entered (when using afterupdate event)

however the spell checker continues on to check other text box controls! text fields that are locked and do not require checking.



how do I prevent this?

the code below

'spell check a formfield
Public Sub SpellChecker(TextField As Control)
    
    With TextField
        .SetFocus
        .SelStart = 1
        .SelLength = Len(.Text)
        DoCmd.SetWarnings False
        .SelLength = 0
        DoCmd.RunCommand acCmdSpelling
        DoCmd.SetWarnings True
        .SetFocus
    End With




End Sub

[NTC]

just stick the code into the private sub of the AfterUpdate event itself rather than call it from a module...is definitely one way to go about it.....

[Ruegen]

just stick the code into the private sub of the AfterUpdate event itself rather than call it from a module...is definitely one way to go about it.....

nope (it's what I had first before I turned it into a function anyway) - hasn't solved the issue

[NTC]

hmmm well sorry for the bad advice...the culprit I presume is:
DoCmd.RunCommand acCmdSpelling

are there any parameters able to be strung along to lasso it down an individual control? I only ask as I see no commas trailing where options can be included......it's not a method I use so one would have to inspect what other properties may be in this acCmdSpelling definition/method.....

[Ruegen]

hmmm well sorry for the bad advice...the culprit I presume is:
DoCmd.RunCommand acCmdSpelling

are there any parameters able to be strung along to lasso it down an individual control? I only ask as I see no commas trailing where options can be included......it's not a method I use so one would have to inspect what other properties may be in this acCmdSpelling definition/method.....

Yeah as far as I can tell I believe docmd.runcomman accmdspelling runs on the form rather than the single control - which isn't much use and I can't edit or get more options/methods etc.

If I could utilise a dictionary file, the same one that the MS office spelling checker uses - I suppose I could write a form that functions as a spell checker.. but that is a heck of a lot of work!!.

[NTC]

guess you have to do something weird to make that field to be in its own table and then inset that field as a sub field.... or trigger an unseen form of just that table and run it there but display the result....

[ISM]

Hi- Read your thread and remembered I was trying to do this at some point awhile ago. I still had a link that helped me and maybe it can help you.

http://www.eileenslounge.com/viewtopic.php?f=29&t=10183