Hi

I would like to be able to update a date to a null value, such as the user has put in a date in error and would like the field to display nothing.

Thanks

Louisa

This is a feature of the database, not the program. You need to set the properties of the column in the table so that it will accept nulls.

Sorry I didn't explain myself properly, what I mean is I use to use the below in VB6, but it is no longer supported, what else can I use?

Dim DTest as date

DTest = null

I have tried :-

DTest = ISDBnull

Thanks

Lou x

A date-type variable can only hold a date. That is the point of strong typing—it forces you to be clear about what you are doing in your code, which in turn reduces the potential for mistakes (both of planning and of keyboarding). (Of course, it can make things harder, too.)

The value of a null in VB is vbNull, btw.

IsDBNull() returns True or False, not a date, (as you have seen).

Perhaps you could tell me a bit more regarding what the larger picture is. I think that you will have to approach this differently—and I have an idea of how you might need to—but I could answer better with just a spot more insight into the process. If you could.

I have a date field that is updated by a user, but what if I put in a date by accident and then he or she wants to replace it with no date as none is actually required.

Louisa

What is this date field part of? A table? A data grid? A textbox on a form?

The date is part of an access table and is populated via a combo box which can be left blank or populated with a date from the combo list. I am having trouble when a user has populated it with a date saved this date to the table and then decides he or she didn't want a date in that field after all and therefore want to save a null value to the table instead of the date currently populating the table.

Thanks

Louisa

I created a table with a date-type column.
I added two rows.
I added dates to both records in Table View mode
I deleted one of the dates. (No problem)

I created a Sub that opened that table as a recordset
I read the value of the column and row that I had deleted the date from in the Immediate Window:
I moved to the row with a date in it.
In the immediate window:   Again, no problems.

Perhaps what you will need to do is intercept changes in the control that is associated with this table column, and if it is set to "" by the user, replace that with a vbNull...