https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/59601.aspxTue, 05 Oct 2010 01:31:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:59601KansasCoder0https://www.infopathdev.com:443/forums/thread/59601.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=59601<p>&nbsp;Hi Tuomo,</p><p>I&#39;m new to InfoPath myself but it would appear that the issue is how the field is being stored in the dropdown. I would check the value that is being used to create the dropdown and see if the culprit isn&#39;t there. You may want to copy that value and paste it into Notepad and then copy the two letters from Notepad into the InfoPath cropdown control. if that is in fact where you are storing these values. <br /></p>https://www.infopathdev.com:443/forums/thread/59463.aspxThu, 30 Sep 2010 07:38:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:59463Tuomo Ilonen20https://www.infopathdev.com:443/forums/thread/59463.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=59463<p>Hi,</p> <p>I have two simple questions</p> <p>1) Does InfoPath2007 have inbuilt function that it removes blank spaces from the end of the value? (e.g &quot;FI &quot; converts automatically to &quot;FI&quot;)</p> <p>2) If so, can I somehow circle around this automation?</p> <p>I have a dropdown list that gets value &quot;FI &quot; from the database (secondary connection). The form sends it to database (main connection) and there the value&nbsp;is &quot;FI &quot;&nbsp;(3 characters). But the form is at the same time submitted also by email; and when someone open the form, the value is &quot;FI&quot; (2 characters).</p> <p>-Tuomo</p>