Results 1 to 3 of 3
  1. #1
    skodger is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2021
    Posts
    1

    how do i add the current time to a form with access 2019


    i am very new to access, and wondered how i can show the current time and date on my forms,
    thank you in advance i am using access 2019
    regards skodger

  2. #2
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    the function Date() will return the current date.
    The function Now() will return the current date AND the current time.

    You can put a textbox on the form and set the Control Source property to =Now() to display the date and time when the form loads.

    Are you wanting to save this to a table?
    Are you wanting a clock?

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,975
    Add an unbound textbox to the form and enter =Now() as the default value or as the control source.
    That will give something like 21/01/2021 16:02:45 if using UK date format or the equivalent in your date settings.
    You can if preferred format to omit the seconds
    However that date/time will stay unchanged.
    if you want the time to be updated every second or every minute, you need to use a form timer event to update it accordingly.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 11-05-2020, 05:45 AM
  2. Replies: 6
    Last Post: 12-09-2019, 05:34 AM
  3. Replies: 8
    Last Post: 07-18-2019, 01:36 AM
  4. Replies: 1
    Last Post: 08-14-2012, 03:22 AM
  5. VB coding to show current date n time in access form
    By cwwaicw311 in forum Programming
    Replies: 6
    Last Post: 02-10-2010, 09:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums