Kayleigh
Member
- Local time
- Today, 22:57
- Joined
- Sep 24, 2020
- Messages
- 709
Hi,
I have the following code on the exit event of several textboxes. I would like to add an input message to ask the user if they wish to go ahead with the spellcheck but only if there it detects spelling errors (ie it shouldn't display when no errors). Any ideas how I could go about this?
One suggestion I was considering was performing a count on the number of errors found and then displaying message if >0 however the only code I found to do this was for a Word doc and I'm not certain that these commands would work in Access...
I have the following code on the exit event of several textboxes. I would like to add an input message to ask the user if they wish to go ahead with the spellcheck but only if there it detects spelling errors (ie it shouldn't display when no errors). Any ideas how I could go about this?
One suggestion I was considering was performing a count on the number of errors found and then displaying message if >0 however the only code I found to do this was for a Word doc and I'm not certain that these commands would work in Access...
Code:
This is my code:
With Me.fldOJobDescription
If Len(.Value) > 0 Then
DoCmd.SetWarnings False
.SelStart = 1
.SelLength = Len(.Value)
DoCmd.RunCommand acCmdSpelling
.SelLength = 0
DoCmd.SetWarnings True
End If
End With
Last edited by a moderator: