InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 21:33:16 GMT20http://forum.strataframe.net/FindPost11314.aspxDoes anyone know the DevExpress DateEdit control settings to show a blank value on the form instead of 1/1/1900 (smalldatetime NULL value) when the field value is NULL in the database table?&nbsp; I think it is a little confusing to the end user to see a date when in fact the field is empty (NULL).</P><P>Thanks SF Team!Thu, 06 Sep 2007 08:46:00 GMTJeff Pagleyhttp://forum.strataframe.net/FindPost11360.aspxAye, it is much more straight forward ;)Thu, 06 Sep 2007 08:46:00 GMTStrataFrame Teamhttp://forum.strataframe.net/FindPost11349.aspxThanks Ben.&nbsp; As a parttimer, I not going to make the effort.&nbsp; I am going to use the&nbsp;SF DatePicker instead.&nbsp; It is more straight forward in handling nulls.</P><P>Thanks!Wed, 05 Sep 2007 12:15:30 GMTJeff Pagleyhttp://forum.strataframe.net/FindPost11339.aspxThe DevExpress wrapper's DateEdit control does not have the same NULL value support that the basic DateTimePicker or the Infragistics wrapper's date editor.&nbsp; There is not currently a way to set the value that should be considered null.&nbsp; You can accomplish this by inheriting the DateEdit and shadowing the DateTime property (you'll have to use the "new" keyword in the property declaration to shadow/hide it).&nbsp; If the value gets set to 1/1/1900, then change the date time format to custom and provide an empty string for the format to blank it out.&nbsp; If the value is different, then reverse it.Wed, 05 Sep 2007 08:56:57 GMTStrataFrame Team