• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1058
  • Last Modified:

ms access vba check memo field text,spelling,grammar

I have tables with memo fields (lots of them) of text, created by field techs, that later are included in client reports. Currently these fields are manually scanned for errors in grammar, spelling, punctuation, etc.. and then corrected.

I would like to auto identify the errors (not correct them) within access and produce a report that identifies the record and the error(s). I'm looking for some code snippets that would help.

1 Solution
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
I use this with the Access runtime and for other custom spell checking solutions: http://www.pcesoft.com/Access-Spell-Checker-Tool-Source-Code.html

It could be modified to do what you want.

PS: It was featured in the Access team blog here http://blogs.office.com/b/microsoft-access/archive/2008/09/04/open-source-spell-check-for-the-runtime.aspx
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now