InfoPath Dev

Hi, I have a field that concatenates 3 values together separated by a |. I'm using a drop down list to display the concatenated field. Those 3 values are all variable length so I wrote a SQL query that pads in spaces to make it so that they are all the same length and use a fixed length font so that the | line up. It works in SQL and returns the expected result, but when the drop down is populated, it looks to be trimming off all of the spaces I've added. Is there a setting I can change or a work around I can do other than adding in underscores?

I'm not seeing this behavior in either InfoPath 2010 or 2007--at least not if I manually add options to a drop-down list. The extra spaces I type in are shown when I preview the form and open the drop-down.

Perhaps the changes are occuring when pulling down the data from SQL?

Could you try padding the values with char(160) instead of ordinary spaces?  I think you might be encountering the behavior described here:

http://en.wikipedia.org/wiki/Non-breaking_space#Use_as_non-collapsing_white-space

Thanks Jimmy, that did the trick.  Just in case others are having the same issue, you can type a non breaking white space by holding down alt, typing 0160 on your number pad, then release alt. It will insert a non breaking white space.