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

  • Thread starter Thread starter abi1008
  • Start date Start date
A

abi1008

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.
 
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?
Click to expand...

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.
 
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?
Click to expand...

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