Hi

I have a bit of a tricky one!

I have 2 fields in an Access 2000 database, CloseDate and CloseTime
that have their properties set to shortdate and longtime respectively.

My app fills in these values without any problem.

However the problem comes when on the rare occasion I will have to
re-open these closed fields and set the date back to blank.
I can do this by opening Access and manually deleting the record but I
can find no way of doing it from my app.

I Have tried setting the corresponding text boxes to "" and " " but
this just generated an error "Data type mismatch in expression".

Does anyone know of a way to do this from VB or will I just have to do
this manually?

I could set the fields back to plain text but this would mess up my
reports when I have to produce reports based on dates/times.

Does anyone have any ideas?

thx.

--
PJ

SQL = "UPDATE MyTable SET CloseDate = NULL, CloseTime = NULL WHERE ( .... );

BTW, there's no need to have two fields for this. Date values include the
time. ShortDate and LongTime are display formats, that have nothing to do
with the field's data format.