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?
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?