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/68768.aspxWed, 27 Jul 2011 12:18:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:68768ahillier230https://www.infopathdev.com:443/forums/thread/68768.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=68768<p>It is database bound; that validation is certainly a good thing!&nbsp; Just exploring some different options because the number of records we&#39;re working with originally exceeds 2,000.</p> <p>Thank you very much for your input!&nbsp; I&#39;m going to have to skip mashing data types together.</p> <p>AKH</p>https://www.infopathdev.com:443/forums/thread/68759.aspxTue, 26 Jul 2011 22:36:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:68759Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/68759.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=68759<p>Well, if your form is database bound (which I&#39;m assuming it is - unless you are using a different approach to submit the data to a DB?) there will be data validation on those currency and date fields based on the data type in the database - which, in my opinion, is a good thing.</p> <p>Rather than mix data types, why not have an additional field for the reason why a field is blank?</p>https://www.infopathdev.com:443/forums/thread/68719.aspxTue, 26 Jul 2011 14:20:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:68719ahillier230https://www.infopathdev.com:443/forums/thread/68719.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=68719<p>Trying to allow date picker and currency controls to accept&nbsp;text values as well.&nbsp; For example, user could set a control to &quot;null&quot;, triggering a drop-down list of reasons why he does not have the information.&nbsp; These values get pushed back to a database.&nbsp; Any ideas are greatly appreciated!</p>