If you are using a macro to enter the date, first test the value of F1 to
see if it is blank.

If Range("F1").Value = "" Then Range("F1").Value = Now()

--
Ian
--
"AccessHelp" wrote in message
...
Good morning,

How can I make the now() function static?

What I am trying to do is we submit our timesheet every week. I have a
macro set up to write the date that submit in Cell F1 using now(). The
problem is when we open the same timesheet next time, the date will change
to
that current date.

I want the date to be the same date that I submit my timesheet and want
the
date to be in the format "10/26/05". I tried using quotes around the
now()
function, and it returns value instead of date.

Any other suggestions are welcomed. Thanks.