Spell checking a single textbox on a form

[LaurieTuff via AccessMonster.com]

I'm trying to use the following code to spell check a textbox (memo field
actually) - called from the AfterUpdate event.
I get an error message saying that "The Macro or function set to the
BeforeUpdate or ValidationRule property for this field is preventing the DB
from saving the data in the field"

There is no ValidationRule set in the underlying table and nothing added to
the BeforeUpdate property.

Can anyone help with this problem, please?

With MemoFiledName
.SetFocus
.SelStart = 0
.SelLength = Len(.Text)
End With
RunCommand acCmdSpelling

Laurie

 

[Marshall Barton]

I'm trying to use the following code to spell check a textbox (memo field
actually) - called from the AfterUpdate event.
I get an error message saying that "The Macro or function set to the
BeforeUpdate or ValidationRule property for this field is preventing the DB
from saving the data in the field"

There is no ValidationRule set in the underlying table and nothing added to
the BeforeUpdate property.

Can anyone help with this problem, please?

With MemoFiledName
.SetFocus
.SelStart = 0
.SelLength = Len(.Text)
End With
RunCommand acCmdSpelling

The text box's BeforeUpdate event does not allow the value
to be set/changed. Use the AfterUpdate event instead.