Auto Spell Check TextBox Control

[Bill Schanks]

Using an Access Project (adp) (Access 2003) file I have this code in my
control's afterupdate event:

Private Sub txtDescription_AfterUpdate()

With Me.txtDescription
.SetFocus
.SelStart = 0
.SelLength = Len(.Text)
End With
DoCmd.RunCommand acCmdSpelling

End Sub

However when I hit change on the spell checker I get:

The macro or function set to the BeforeUpdate or ValidationRule
property for this field is preventing [AppName] from saving the data in
the field.

I have been googling this all morning ... Most solutions have you put
the code in a command button. I would like it to happen as soon as the
field is updated.

I also need it to only check the text box control on the active record
not all records. That is why a simple 'DoCmd.RunCommand acCmdSpelling'
won't do. That will check all records on the form.

Any idea's to get this to work?

 

[Crystal]

put it in the BeforeUpdate event

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com