If you’ve ever wanted to implement some sort of Spell Check functionality within your SalesLogix database, you’re in luck! The Standard Spell Check vbScript makes it simple to add this functionality to your custom forms. *Note: Microsoft Word must be installed on the local machine.
For this example, I’ll set up Spell Check functionality in a standard Memo field. There are two ways to implement this sort of functionality:
1: Using the Standard Memo popup. This method will launch an generic edit view for the memo field which includes “Spell Check” as a right-click menu option.
First of all, we need to create a form. For this example, we simply need an Account form containing a Memo control, and a button to launch the Standard memo popup.
In the code for this form, we will first want to include the System:Spell Check. Once the script is included, add the following code to the Button’s click event:
InvokeStandardMemoPopup Memo1, “Spell Check This form”, False
This subroutine takes three parameters. The first is the name of the Memo control, followed by a Caption for the form we are launching. The final parameter is a boolean designating if a time/date stamp should be added to the invoked form.
Upon clicking the button, you are now presented with the standard memo popup view.
If you right click in the view, you will see a “Spell Check” item included in the menu.
That was pretty easy to set up. However, if you don’t want to present an additional view to the end user, you can add the functionality directly into your memo control.
2: Adding spellcheck functionality to a memo control.
We’ll use the same form as before, but we will need to add A PopupMenu control to the form. We’ll need to set up the PopupMenu items to include “Spell Check” as a menu item. Double click the PopupMenu’s Items property and add these items:
We’ll also need to add the following code to the PopupMenu control’s “OnClick” event:
Sub PopupMenu1Click(Sender, ByRef MenuItem)
StandardOnPopUpMemoClick Memo1, MenuItem.MenuIndex
The last step is to add this code to the Memo control’s “MouseDown” event:
Sub Memo1MouseDown(Sender, Button, X, Y)
If Not Sender.ReadOnly And Button = 1 Then
StandardMemoMouseDownEvent Memo1, PopupMenu1
This code checks to see that the memo control is not read-only, and that the right mouse button has been clicked. Then you just pass the Memo control and PopupMenu control to the StandardMemoMouseDownEvent subroutine.
There you go! You’ve just used the Spell Check script included in SalesLogix to add Spell Check functionality to your custom form. I hope you find this article helpful! Thanks for reading![:)]