removing date from database record -

[John L]

Using VB5 and Access 7 database.

Not sure how to describe this problem - but I have 2 text boxes in a
database program - they store a date and the properties in the DB are set as
date/time.

Works fine, but if I choose remove the date, when I restart the program the
date is back filled back in by the database records I assume - can't seem to
get rid of it once it's stored.

I've tried to get the recordset to update with the blank field before the
exiting the program, but that only gives me an error from VB...

Any tips? Can't seem to locate previous comments on this.

TIA - John

[AK]

"John L @yahoo.com>" <john_stlmo<removethis> skrev i en meddelelse
news:mvi1e.10141$lk5....@fe06.lga...

When binding a List -or Combo -box to a dataBase
the Clear property is not functioning. I think the
textBox is functioning likewise, that is, you're not
allowed to blank it enthough, I have
no experience with it.

[Michael B. Johnson]

You may need to set the date to NULL in your database, whenever the
date typed in is blank AND you are updating the database.

<aircode>
' rs is your Recordset.

If Len(Trim(txtDateField.Text)) = 0 Then
rs.Fields( "MyDateField" ).value = Null
Else
rs.Fields( "MyDateField" ).value = txtDateField.Text
End If

</aircode>

Hope I've understood your issue correctly...
_______________________
Michael B. Johnson