# Access Question

**URL:** <https://boards.straightdope.com/t/access-question/343284>\
**Category:** Factual Questions\
**Created:** [February 6, 2006, 7:52pm UTC](https://boards.straightdope.com/t/access-question/343284 "2006-02-06T19:52:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MannyL](https://avatars.discourse-cdn.com/v4/letter/m/ba8739/32.png) [@MannyL](https://boards.straightdope.com/u/MannyL)\
**Post date:** [February 6, 2006, 7:52pm UTC](https://boards.straightdope.com/t/access-question/343284/1 "2006-02-06T19:52:35Z")

</div>

I need to know how to force today’s date into a field on an Access Database for a new record and then prevent the changing of that date

Any suggestions that don’t rely on VBA?

---

<div class="post-metadata">

**Author:** ![Shagnasty](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Shagnasty](https://boards.straightdope.com/u/Shagnasty)\
**Post date:** [February 6, 2006, 7:59pm UTC](https://boards.straightdope.com/t/access-question/343284/2 "2006-02-06T19:59:59Z")

</div>

Need more info. A function can do it from an update query. If it is a form, there are several ways of writing the current date. The last step will be to lock the field from user input which can be done through properties.

I have a feeling that you just want a date stamped on the table. In that case, create a new Date/Time field in the table and set the default value to NOW().

---

<div class="post-metadata">

**Author:** ![ultrafilter](https://avatars.discourse-cdn.com/v4/letter/u/3d9bf3/32.png) [@ultrafilter](https://boards.straightdope.com/u/ultrafilter)\
**Post date:** [February 6, 2006, 9:04pm UTC](https://boards.straightdope.com/t/access-question/343284/3 "2006-02-06T21:04:48Z")

</div>

Do you need the date when the record was created, or the date when it’s viewed? It’s not clear from the OP.

---

<div class="post-metadata">

**Author:** ![MannyL](https://avatars.discourse-cdn.com/v4/letter/m/ba8739/32.png) [@MannyL](https://boards.straightdope.com/u/MannyL)\
**Post date:** [February 7, 2006, 3:33am UTC](https://boards.straightdope.com/t/access-question/343284/4 "2006-02-07T03:33:44Z")

</div>

> [@ultrafilter](#):
>
> Do you need the date when the record was created, or the date when it’s viewed? It’s not clear from the OP.

I figured out what they were doing wrong. They had =date() in the wrong field so it was always updating to the current date when a record was viewed not the date the record was created.