In Access, I am trying to trim the spaces off of a field before it updates (or validates). The following code is returning error "2115: The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing EditPro from saving the data in the field."
Private Sub txtIllustrations_BeforeUpdate(Cancel As Integer)
'// Trim spaces
Me!txtIllustrations = Trim(Me!txtIllustrations)