Auto Spell Check TextBox Control

  • Thread starter Thread starter Bill Schanks
  • Start date Start date
B

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?
 
put it in the BeforeUpdate event

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 
Back
Top