paulmcneil
asked on
Spell check in Access 2010 VBA
I get runtime err 2046, the command or action ‘spelling’ isn’t available now.
when I run the following code in AfterUpdate property of a memo field.
Private Sub DegreeofAttainment_AfterUp date()
'If the text/memo contains data run the
'Spell Checker after data is entered.
If Len(Me!DegreeofAttainment & "") > 0 Then
DoCmd.RunCommand acCmdSpelling
Else
Exit Sub
End If
End Sub
when I run the following code in AfterUpdate property of a memo field.
Private Sub DegreeofAttainment_AfterUp
'If the text/memo contains data run the
'Spell Checker after data is entered.
If Len(Me!DegreeofAttainment & "") > 0 Then
DoCmd.RunCommand acCmdSpelling
Else
Exit Sub
End If
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Found my own solution
Me.DegreeofAttainment.SetF
Also, SpellCheck must be installed (it's installed with Office, not Access) and you cannot do this in the Runtime environment (i.e. if you're running Access Runtime vs the full retail version of Access).