spellchecking and beforeupdate error

[Andre C]

I am receiving the following error

The macro or function set to the beforeupdate or validationrule
property for this field is preventing CCN caseloads from saving the
data in this field.

The field is part of a form witha number of memo fields in which teh
user writes reports. I wanted spell checking automatically so I
inserted the following code into afterupdate event

Private Sub Text54_AfterUpdate()

' the following four identical routines allow for spell checking
'of the four assessment memo boxes.

'An error routine should catch empty boxes.

On Error GoTo err_text54_AfterUpdate

Me!Text54.SelStart = 0
Me!Text54.SelLength = Len(Me!Text54)
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True

exit_text54_AfterUpdate:

Exit Sub

err_text54_AfterUpdate:

Resume exit_text54_AfterUpdate
End Sub


There is no validation rules on this field. I habve also put this code
into the veforeupdate field but with a similar message. originaly I
had this code in lostfocus with an extra line to redirect focus. This
worked with no problems but made navigation unsmooth. I have changed
nothing else so I am unclear why this now fails.

Following a Google search I have been through the associated table and
removed all vlaidation rules. I validate data on the form within each
control. But still this does not relieve the problem.

Any clues?

 

[RuralGuy]

I have heard that the SpellChecker tries to save the record.

I am receiving the following error

The macro or function set to the beforeupdate or validationrule
property for this field is preventing CCN caseloads from saving the
data in this field.

The field is part of a form witha number of memo fields in which teh
user writes reports. I wanted spell checking automatically so I
inserted the following code into afterupdate event

Private Sub Text54_AfterUpdate()

' the following four identical routines allow for spell checking
'of the four assessment memo boxes.

'An error routine should catch empty boxes.

On Error GoTo err_text54_AfterUpdate

Me!Text54.SelStart = 0
Me!Text54.SelLength = Len(Me!Text54)
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True

exit_text54_AfterUpdate:

Exit Sub

err_text54_AfterUpdate:

Resume exit_text54_AfterUpdate
End Sub


There is no validation rules on this field. I habve also put this code
into the veforeupdate field but with a similar message. originaly I
had this code in lostfocus with an extra line to redirect focus. This
worked with no problems but made navigation unsmooth. I have changed
nothing else so I am unclear why this now fails.

Following a Google search I have been through the associated table and
removed all vlaidation rules. I validate data on the form within each
control. But still this does not relieve the problem.

Any clues?

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Guest]

See my post in the thread labeled:
spell checker cycles thru all records behind a form

Hope this helps.

 

[Andre C]

See my post in the thread labeled:
spell checker cycles thru all records behind a form

Thanks for this. It is still disappointing not to be able to
automatically spell check unless I put it in lostfocus event.