Access: Time Function

In Access, the Time function returns the current system time.

The syntax for the Time function is:

Time ()

For example:

Time() would return a value such as '10:42:58 PM'

VBA Code

The Time function can be used in VBA code. For example:

Dim LValue As String

LValue = Time

In this example, the variable called LValue would now contain the current system time.

You can also use the Time function in a query.