Others

Set the Current Time in a Bound Microsoft Access Form Field

Elise WilliamsElise Williams Nov 14, 2026 868 views

Question details

Set a bound Microsoft Access form field to the current time when the form opens.

Set the Current Time in a Bound Microsoft Access Form Field
Product
Microsoft Access
Device & OS
not provided
Scenario
A user wants a bound form control to receive the current time when an Access form opens.
Observed behavior
The desired result is for the editable record's bound field to contain the current time.
Before you start

Open the form in Design View and check the control's Name and Control Source properties. Confirm that the underlying field has a Date/Time data type and that the form and record allow edits.

Solution 1Recommended

Set the bound field in the form's On Load event

Use this method to assign the current time to the form's current record when the form opens.

1
Open the form properties

Right-click the form in the Navigation Pane and select Design View. Open the Property Sheet and select Form from the selection list.

2
Create the event procedure

On the Event tab, find On Load, select [Event Procedure], and click the ellipsis button to open the VBA editor.

3
Assign the time

Inside the Form_Load procedure, add `Me.Controls("TimeUpdated").Value = Time()`. Replace TimeUpdated with the actual name of the bound control.

4
Test the form

Save the form, close it, and reopen it in Form View. Check the bound field and save the record if you want to retain the change.

Set the bound field in the form's On Load event
Existing values can be replaced: On Load runs when the form opens and can overwrite the time in the current record. Time() supplies a time value without preserving an existing date; use a condition or a different event if that is not intended.
Free Microsoft Office alternative

Work with exported Access data in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface for working with exported tabular data. Export Access data to an Excel workbook or CSV file to move it into WPS Spreadsheets; WPS does not run Access forms or VBA form events.

Review and edit exported Access table data in a spreadsheetOpen and edit Microsoft Excel XLSX workbooksUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Should I use On Load or On Current for the time field?

Use On Load to set the field when the form opens. Use On Current when the assignment should be evaluated as you navigate between records, and add a condition if you do not want to overwrite existing values.

How do I check whether the control is bound?

In Design View, select the control and open the Property Sheet. On the Data tab, check that Control Source names the intended field; on the Other tab, check the control's Name for use in VBA.

Why can't Access write the time to the field?

Check that the underlying field supports a Date/Time value and that the form's record source and record are editable. If an error appears, note its exact number and message before troubleshooting further.

Will Time() preserve an existing date in the field?

No. Assigning Time() replaces the field value with the current time value, so it does not preserve an existing date. Use a different expression if the date must be retained.