=date() not able to display time in query

am using the = date() in a invisible textbox on a form- users enter data in-
now admin wants to be able to see the date and time
cannot seem to have it display in a date time ( general) format- tried changing it in query and also in properties of table-
any ideas what I can do to have it display date and time?
thank you
Who is Participating?
Rey Obrero (Capricorn1)Commented:
use  =Now()  instead of Date()
Helen FeddemaCommented:
You may also need to select the correct format for the textbox, probably General Date
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.