Improved Spelling and Grammar Checker

billgyrotech

Banned
Local time
Today, 16:17
Joined
Apr 18, 2013
Messages
258
Hello,


Can some fields on my form have a spelling and grammar checker?


If so is this done with programming?


Thank you very much in advance for your help,
Bill
 
Thank you Uncle Gizmo I will give it a try.
 
Hello All,


I wanted to share code provided by Missinglinq from another post that I found:


Code:
Public Function SpellChecker() 
Dim ctrl As Control 
Dim frm As Form 
Set frm = Screen.ActiveForm 
DoCmd.SetWarnings False 
For Each ctrl In frm.Controls 
	If TypeOf ctrl Is TextBox Then 
		If Len(ctrl) > 0 Then 
			With ctrl 
			.SetFocus 
			.SelStart = 0 
			.SelLength = Len(ctrl) 
			End With 
			DoCmd.RunCommand acCmdSpelling 
		End If 
	End If 
Next 
DoCmd.SetWarnings True 
End Function

Then put "Call SpellChecker" either in a button or within one of your printing codes.

This works very well and checks the form for errors. I really appreciate that I don't have to put code in each textbox.

Thank you Missinglinq for your fantastic method.

--Reformatted for readability-jdraw
 
Last edited by a moderator:

Users who are viewing this thread

Back
Top Bottom