Add a Spell Check to Extended Description, Memo's, Notes, UDF and other Text Box Fields - PLEASE VOTE!

It would be great to have a Spell Check to find common spelling errors in Sage 100!

This would eliminate embarrassing misspelling on invoices and other documents that go to customers and/or vendors.

• Have the ability to turn the Spell Check on/off in Library Master and at a field level for (UDF Text Box fields).
• Have the ability to add words or phrases (similar to Zip Code Maintenance).

PLEASE VOTE!   

https://www11.v1ideas.com/SageERP/MAS90and200/Idea/Detail/3837 

  • Actually there use to be one. Slade, the Obe Wan of MAS90 had written a script that created a spell checker. Worked great. It's a little dated but you should be able to update. This script was attached to a button on the panel.

    ' ---------Script Start---------
    ' Slade Hornick
    ' Original 01/30/2004
    ' Using Microsoft Word's Spell Checker for Extended Descriptions
    function Spelling(TextValue)    
     Dim objWord, objDocument, strReturnValue    
     Set objWord = CreateObject("word.Application")    
     objWord.WindowState = 2    
     objWord.Visible = False    
     'Create a new instance of Document    
     Set objDocument = objWord.Documents.Add( , , 1, True)    
     objDocument.Content=TextValue    
     objDocument.CheckSpelling    
     'Return checked text and quit Word    
     strReturnValue = objDocument.Content    
     objDocument.Close False    
     objWord.Application.Quit True    
     Spelling=strReturnValue
    End function
    ' Convert the carriage returns to what Word wants
    'ml_memo=Replace(ml_memo,chr(138),vbCR)
    ml_memo=Spelling(ml_memo)
    ' Convert the carriage returns back to what MAS90 wants
    'ml_memo=Replace(ml_memo,vbCR,chr(138))
    '----------Script End---------

  • in reply to BigLouie

    So.... I can have my IT department add this script to Sage100 and this will allow spell check?

  • in reply to brookem

    You need to create a button on the panel and attach the script to the button. Will need to update script to current field names but yes this will allow spell check.

  • in reply to BigLouie

    Really don't want to have to rely on a user to hit a button and keep hitting buttons to say "Change" or "Ignore"

    Would rather have the spelling being checked as the user types.   Red line any errors, similar to Outlook Word, etc...

    Great little script for those that choose to use it though.   Thanks Big Louie!   Hope to see you at Summit!