VB6/ACCESS: Nulls in Date Field shows 12:00:00 AM

[Angel2dna]

I have a VB6App connected with Jet 4.0 to an Access Database
I'm using a ADODC to connect a Data Repeater Control which
contains a date field. Everything works great, except the where there is no information entered for the Date Received field. When the application is run, the Date Received field displays 12:00:00 AM for any empty values in that field. I just want the display to be blank if there is no date value for that record in this field. How can I code for this and where do I put the code? In my User Control or can I code for the Data Repeater in the form where I placed my Data Repeater control? Any input is greatly appreciated!

[compuGEEK]

This will check the current value of that field. It works if you convert a null to an empty string:

form.textfield=format(rs("Field")

[JHausmann]

If that doesn't work, try

if cint(Date_received_field)= 0 then
form.txtfield=" "
end if