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/108110.aspxWed, 28 Sep 2016 14:17:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:108110arkainus0https://www.infopathdev.com:443/forums/thread/108110.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=108110I&#39;m not sure if this is even possible, but I figured I&#39;d ask and see if anyone has a solution for this.<p>I have a form, that I&#39;ve hooked in via code to search an SQL Table for a product that we use on-site. This SQL table is from a vendor, so I cannot modify that structure without risk of breaking something in the program that utilizes it. The table I search has contacts in it, each contact has a primary key associated with it (in this case, dubbed &quot;event_code&quot;) Event_code is varchar(7), and they&#39;ve utilized some sql triggers to increment a counter for each new contact that gets added. Their triggers prepend white space for event_code&#39;s shorter than 7 characters (i.e. event_code 10883 is saved in the database as &#39; 10883&#39;. I&#39;ve implemented the functionality so that each result gets populated into a repeating table. From there, they have an ability to check a box on that repeating table row, and I&#39;ve implemented a button that will do some logic based on their selections, and copy info from the sql table into the form (and insert rows into a different database automatically). This works great if the event_code is exactly 7 characters, not so good on the older contacts from 20+ years ago that we still do business with that have the shorter codes.<p>The tricky thing is an infopath textbox field seems to strip leading whitespaces on the textbox once focus has been shifted from the field, so I can never get the value of the textbox to be &#39; 10883&#39;. Is there a way to prevent this? A way to keep the verbatim entry? My trusty google searches have so far turned up bupkis - results are mostly for people asking how to prevent whitespace in a textbox. I suppose I can implement in my code string.length checks, and prepend the white space manually based on the returned length, but I was just hoping there&#39;s something super easy that I&#39;ve missed. As always, any insight/help here would be greatly appreciated!