>The foxpro ODBC driver converts empty dates to 12/30/1899 because there is no concept of empty dates in ODBC.
>
>
>The blank date and the Null date are not the same. You will get Null date thru ODBC only if you allow null in the date field in foxpro and replace empty dates with nulls.
>
>>
>
>This affects only INSERT command. If you set Null ON, INSERT – SQL inserts a null value into any column not included in an INSERT – SQL… VALUE clause. A blank is inserted if Null is OFF.
>



Hi Sergey,

Okay, so I modified the table to allow null values in the date_foal field and then replaced all the "blank" fields with the value ".null.".

I ran the Crystal report and it now shows the values for the date_foal field as blank.

The problem now is that the field on the form that has the date_foal as the control source shows ".null." rather than " / / " as before.

I've tried to get around this by using the code below but it always shows ".null." in the textbox.


ThisForm.Text1.value = iif(date_foal = null,ctod(" / / "),date_foal)

Is there a way to show blank or empty fields for null values?

Jim
jharvey@netrax.net