When designing a form, one of our requirements is to allow the end user to enter text such as "Police Uniform" for a description.  However if the user types "Police Uniform    " (spaces), we want to trim the field.  So I turn on Trim Right in the BO.  Now I cannot type a space after the letter "e" in police. 

So I was advised to change the BindingUpdateMode to "OnValidation".  Now when I add a new record, type in a description like above, the description is NOT saved and is blank in the database and is displayed as blank on the UI form!

What gives?

Ben

OK, so how do I manually fire the event(s) in the BeforeSave?

So far I have:

For Each lcControl As Control In Me.Controls
     WHAT GOES HERE?
Next

I have tried RaiseEvent but it complains that I cannot call base class events directly.

Ideas?

Ben

You can raise the event from within the control by calling Me.OnValidating() or Me.OnValidated().  However, those methods are protected, so you will have to create your own textbox control and create public methods that call the protected methods.  Or you can use reflection to get the MethodInfo and invoke it on the control.  Reflection is slow and requires a good bit of code to execute a single method, but you can do it from anywhere.