spell checker


S

Sam

I have a form whose recordsource is a pass through from SQL. The spell check
icon is disabled. Is there any way to get Access to allow a spell check? I
have other code that will save edits but can't get spell check working.

Thank you
Sam
 
Ad

Advertisements

A

Arvin Meyer MVP

Try putting this in a module. Do not name it the same as the function, and
call the code from a command button:

Public Function Spell()
' Arvin Meyer 9/17/1998
' Adapted from code by Terry Wickenden
Dim ctlSpell As Control
Dim frm As Form
Set frm = Screen.ActiveForm
DoCmd.SetWarnings False
' Enumerate Controls collection.
For Each ctlSpell In frm.Controls
If TypeOf ctlSpell Is TextBox Then
If Len(ctlSpell) > 0 Then
With ctlSpell
.SetFocus
.SelStart = 0
.SelLength = Len(ctlSpell)
End With
DoCmd.RunCommand acCmdSpelling
End If
End If
Next
DoCmd.SetWarnings True
End Function

If it doesn't work, you may have to reinstall Office.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top