Using =now() - Is it possible to override this?

  • Thread starter Thread starter denilynn
  • Start date Start date
D

denilynn

I'm using the =now( ) function to return the current time.
How can I set this field up so that it will also allow the
user to type in a different time? Thank you in advance!
 
denilynn said:
I'm using the =now( ) function to return the current time.
How can I set this field up so that it will also allow the
user to type in a different time? Thank you in advance!

Use =Now() for the default value rather than the ControlSource.
 
If you use Now() in the Default property of the table itself, then when the
record is created, it will have the current date and time, but the user can
type something else in.
 
I'm using the =now( ) function to return the current time.
How can I set this field up so that it will also allow the
user to type in a different time? Thank you in advance!

Set the Default property of a table field, or of a textbox bound to a
table field, to Now(). Using =Now() as the control source of a textbox
doesn't store the information anywhere, and cannot be edited.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top