combobox bound cant trim whitespace?

[cwfontan]

Returns a list of customers with whitespace on the end.. very annoying

what can i do to trim in code behind?
Also if I bind using the databinding on smart tag is there a way to trim?

        cbo_customer.DataSource = M8CustomersBindingSource
        cbo_customer.DisplayMember = BA_TruckingDataSet.M8_Customers.CustomerNameColumn.ToString.Trim
        cbo_customer.ValueMember = BA_TruckingDataSet.M8_Customers.CustIDColumn.ToString.Trim

thanks

 

[JohnH]

You can for example set FormattingEnabled and handle Format event like this:

If e.DesiredType Is GetType(String) Then
    e.Value = e.Value.ToString.Trim
End If

Strings doesn't have any custom format specifiers so you can't set any FormatString to enable trim.

 

[cwfontan]

Found out what it was.. wow.. some how all the spaces where char(160) instead of char(32)...

did a replace and trim workss..

 

[JohnH]

That is a common character, but easy to miss in some cases, it's called Non-breaking space - Wikipedia, the free encyclopedia and also works in for example the .Net Textbox when text is wrapped. You don't need to replace it before trimming because String.Trim Method (System) includes this and lots of other whitespace characters.