Data Entry -s it possible to show current date that doesn't change the next day?

[HRN_SciTech]

Hi there,

I am extremely new to Access. I have my database up and running ok(ish) and would like to know if in my data entry form, I can have the "Date Entered in Database" box display the current date that does not change from day to day.

I know you can use the "Now()" function but won't this just change everyday?

Cheers
Hayley

 

[pbaldy]

Use a textbox with a default value of Date() or Now(), bound to the field in the table.

 

[HRN_SciTech]

Use a textbox with a default value of Date() or Now(), bound to the field in the table.

Thanks very much

 

[pbaldy]

No problemo!