I have an InfoPath 2007 form populating from a SQL statement with formcode from VS.NET 2008. Everything works great except, I have textbox that I need to keep spaces in, i.e. my SQL delivers the value "Jessie Smith" (and I have verified that the SQL is indeed returning that value), but on the InfoPath form the textbox value displayed is "Jessie Smith". How do I tell this control to keep the spaces that I want?
Thanks,
Chera