Improved Spelling and Grammar Checker

[billgyrotech]

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

 

[Uncle Gizmo]

This Post maybe of interest:-

https://access-programmers.co.uk/forums/showthread.php?p=767936#post767936

I also have an example application with a pop-up spellchecker form, it it's a bit primitive as I wrote it in 2008, I need to update the class module to my latest version Before I can share it, not sure when I'll be able to do that.

 

[billgyrotech]

Thank you Uncle Gizmo I will give it a try.

 

[billgyrotech]

Hello All,


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

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