Blanking out a date -- how to

J

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
 
J

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
 
V

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.
 
Top