Blanking out a date -- how to

[John Baker]

Hi:

I have a set of records and I want to blank out a date (set it to blank). I am darned if I
can do it! Using SetValue I need the parm to set the date to the equivalent of spaces or
the entry made by the space bar, or blank.

Can someone help on this trivial issue please.

Thanks

John Baker

 

[Van T. Dinh]

Null perhaps.

Check Access Help on UPDATE Query.

 

[John Baker]

Thank you.

I had tried that and it didn't work. In fact it adversely affected many macros that are
perfectly happy when i put in a space!

I also tried "", but that had the same effect.

When i insert a blank (using the space bar) things work fine!

Further suggestions much appreciated.

best

JOhn Baker

 

[Joseph Meehan]

Thank you.

I had tried that and it didn't work. In fact it adversely affected
many macros that are perfectly happy when i put in a space!

I also tried "", but that had the same effect.

When i insert a blank (using the space bar) things work fine!

Further suggestions much appreciated.

Try " "

"" has no space.

 

[Van T. Dinh]

If you want to change the values for a whole set of Records, much better to
write an Update Query than to type new value / to delete old values for each
Record. The Null was meant to be used in an Update Query.