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

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

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