Could we have a checkbox on the validate tab of a field to left justify the field please Bruce?
Reason being I just had a case where client entered a category as ' General' for some reason.
This causes all sorts of problems because the lookup fails on the item assigning the category to, but the actual error is never reported. So it looks like it worked but didn't.
This is not the first time I've come across this.
I'm currently doing a field=LEFT(field) in validateValue but a checkbox would be way easier