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

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!
 
R

Rick Brandt

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.
 
R

Roger Carlson

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.
 
J

John Vinson

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

Top