This article is about to enable spell checker functionality on update event of Memo field. The spell checker option mostly used in those databases where comments are added frequently. For that spell checker options become key feature. For implement the spell checker we are using VBA code on after update event of memo field. Whenever the spelling error happens the spell checker automatically detect the error when we are saving the text.
To implement spell checker firstly we have to create a table and form with text filed. Bind this form with table and text-box with its text field as shown in Fig 1.1.
Now we have to implement spell checker on after update event of textbox. After implementation we have to test spell checker. As we save misspelling text the spell checker automatically detect the error and provide the suggestions to correct it as shown in Fig 1.2.
As we check the on ok button the spelling is change to correct one as shown in Fig 1.3.
Option Compare Database Private Sub txtTest_AfterUpdate() If Len(Me!txtTest & "") > 0 Then DoCmd.SetWarnings False DoCmd.RunCommand acCmdSpelling DoCmd.SetWarnings True Else Exit Sub End If End Sub
It is advised that the information provided in the article should not be used for any kind formal or production programming purposes as content of the article may not be complete or well tested. ERP Makers will not be responsible for any kind of damage (monetary, time, personal or any other type) which may take place because of the usage of the content in the article.