Spellcheck with MS Access 2007 runtime

[henley12]

Is there a way to get Spellcheck to work with MS Access 2007 Runtime version? Perhaps I am missing something simple. Thanks.

 

[TheAceMan1]

How are ya henley12 . . .

As a first shot ... try the following (you'll have to incoorperate in the origional mdb then convert to the runtime again):

[blue]Public Sub SpellCheck(Optional ctl)
   Dim flg As Boolean
      
   If IsMissing(ctl) Then
      DoCmd.RunCommand acCmdSelectRecord
      flg = True
   ElseIf ctl.ControlType = acTextBox Then
      ctl.SelStart = 0
      ctl.SelLength = Len(ctl)
      flg = True
   End If

   If flg Then DoCmd.RunCommand acCmdSpelling

End Sub[/blue]

[red]Do not use the routine in any Focus or Update event because errors are raised as the events are trying to save while the spellchecker is trying to edit![/red]

Example using the DoubleClick event of a text/memo control to spellcheck only the text/memo control on any form/subform:

[blue]   Call SpellCheck(Me!TextboxName)[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]