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