How to add blank date to recordset??

[Mark Burns]

How do I add a date to a recordset? My app is user interface to an access
db which loads records from the database. But if user wants to add records
I am having problems with adding to date fields. I would like to add a blank
record but using the addNew method as below I seem to have to add a value.

This is how I have been adding records. Is there any way to do this with
the = expression??

recordset.AddNew

recordset!Date = "4/4/44"

recordset.Update

I can get away with (= "") for textfields, but for dates it seems I have
to add a real date.
Any help would be greatly appreciated
Mark Burns

[Mark Burns]

Nevermind, I thought I had tried to AddNew without specifying the individual
fields before and it didn't work, but I guess not. If I don't specify the
fields then each record not specified is blank

Mark

[Arthur Wood]

Mark,

In addition, when you do supply dates, you sould either use the CDate
function, or delimit the date values with #s:

rs!DateField = "#4/4/01#"

the # is the H+Jet dlimiter for Date values.

Arthur Wood


"Mark Burns" <mburns@slip.net> wrote:
>
>Nevermind, I thought I had tried to AddNew without specifying the individual
>fields before and it didn't work, but I guess not. If I don't specify the
>fields then each record not specified is blank
>
>Mark