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

If you change the textboxes BindingUpdateMode to OnValidation, then you can use the trimming as you would like.  There is one problem though, you must validate the field before the changes are commited to the property.  So if you make a change and tab, it will definitely work.  But if you make a change and then click the Save button on a MaintenanceFormToolstrip (without tabbing), it may not fire the validation.

You can handle the BeforeSave event and force the textboxes to validate.