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

(Sorry I posted this in the wrong newsgroup (issues))

I am adding the code to BeforeSave as you suggested.  How do I fire a validate event for controls correctly so the BO properties get updated with the new values?

For Each lcItem As Control In Me.Controls
What goes here? I do not see an lcItem.Validate() option
Next

Thanks!

Ben