Time Function

Description

Returns a Date indicating the current system time.

Syntax

Time

Remarks

To set the system time, use the Time statement.

See Also

Date Function, Date Statement, Time Statement, Timer Function.

Specifics (Microsoft Access)

You can insert the current time on a form or report by clicking Date And Time on the Insert menu. This command creates a text box on a form or report and sets the ControlSource property of the text box to the expression =Time(). It is available only in form Design view and report Design view.

You can also use the Time function in a query expression or in a macro. However, you must include the parentheses after the function when you use it anywhere other than in a Visual Basic module, as in the expression Time().

Example

This example uses the Time function to return the current system time.

MyTime = Time    ' Return current system time.

You can use the Time function in a calculated control to return the current system time. For example, you can create a text box and set its ControlSource property to the following expression.

= Time()