Need to keep spaces in textbox

[cherab]

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