The majority of string fields in our legacy database are defined as Char(). When you bind these fields to TextBoxes/ComboBoxes they are padded to the maximum field size. I am looking for a way to trim the fields before they are bound to controls to simplify editing without having to write a bunch of code.

I have tried setting the trim options within the BO Mapper customization section but that prevented entering text with spaces, ie 'StrataFrame Rocks'.  I then found a few postings suggesting to change the BindingUpdateMode = OnValidation.  This works fine if you leave the field and then click on save. If you click on save before leaving the field, the value isn't changed and I'm not sure how to solve this... apparently it's a bug in VS.

I then tried adding a routine to loop through the 'AllFieldsList' and trim the string fields, as suggested by Ben in one of the posts. This kind of worked on the textbox controls but not the combobox controls, plus it caused a problem with the navigation buttons on my toolbar.

I'm sure there must be a way to handle this situation without changing the field types in the database. Any suggestions will be much appreciated.

Thanks,

Tim