Simple form problem

[tom]

I want a form to put now() with only date data and not
time date in a bound control only if that record is null
in that field.

 

[Jeff L]

Use Date() instead of Now().

Hope that helps!

 

[Jeff Boyce]

Tom

Then don't use "Now()", which stores date AND time. Use Date() instead,
which only stores date info.

If you are using a form and want the field to be filled with Date() if it is
a new record, use =Date() as the Default value property.

If you want to update a set of records that have no data in that field, you
could use an update query, but think twice about doing this. If you have a
record from 2 years ago but update the date field with today's date, will
that make (business) sense in your situation?

Regards

Jeff Boyce
Microsoft Office/Access MVP