how do i set an autodate on access without it changing?

basically im creating a database/form at work and need a automatic date in on
field for the day the record is completed. however this date has to remain
the same. any ideas how ot do it?

If what you are asking is how do I put the date a record was created in a
field in the record, but not ever change it, it is fairly simple.

You just need a text box control on you form that is bound to the field.
Since you will not be entering anything, you can make it invisible. In the
Default Value property of the text box just put:

If you want just the date use:

=Date()

If you want the date and time use:

=Now()

The Default Value only affects new records.

--
Dave Hargis, Microsoft Access MVP


"abi1008" wrote:

basically im creating a database/form at work and need a automatic date in on
field for the day the record is completed. however this date has to remain
the same. any ideas how ot do it?

On Tue, 26 Aug 2008 08:48:00 -0700, abi1008 wrote:

basically im creating a database/form at work and need a automatic date in on
field for the day the record is completed. however this date has to remain
the same. any ideas how ot do it?

Your message is not clear.
Try telling us in different words what it is you are wanting to do.
Perhaps, also, an example.

You might also think about proper capitalization and punctuation. It's
to your advantage to make your message easily understood by others.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Tue, 26 Aug 2008 08:48:00 -0700, abi1008
wrote:

basically im creating a database/form at work and need a automatic date in on
field for the day the record is completed. however this date has to remain
the same. any ideas how ot do it?

Set the DefaultValue property of the table field, or if you prefer the form
control, to =Date(). On a Form, set the Locked property of the textbox bound
to this field to Yes so the user can't overtype it.

--

John W. Vinson [MVP]