MEMO datatype

[alec]

I posted this question last week, got several help tips but did not help, I still appreciate all of you who have tried to help me.
I thought I found the answer but still don't know how to fix so I need help again from you.

I have a form with several textboxes. I need to create spell checking button so that during editing before saving it user can do spell checking.
with my current one line code, my spell checking functionality is working partially, meaning that it corrects the incorrect words within each textboxes; but when it is done I'll get either:
- Error message :"Application-defined or Object-defined
error 9536" or
- my computer comes to a stall

After weeks of debuging, i found out that the problem maybe due to a few of the textboxes are set as MEMO instead of TEXT datatype.

I read somewhere in Microsoft knowledge based that spell checking functionality work only with field that store text but not numbers or other data types including Memo datatype

I can't change the datatype from memo to text to solve this problem since Memo datatype is needed for my form.

Does anyone know how to get around this problem? Thank you - Alec

 

[jimmythegeek]

I have used spell check on memo fields many times with no problems. In fact I just tried this on a memo field and worked fine. I looked at your last posts, and all I can suggest is to use the following line of code instead of SendKeys.

DoCmd.RunCommand acCmdSpelling Jim Lunde
compugeeks@hotmail.com
Custom Application Development