Set the Current Time in a Bound Microsoft Access Form Field
Question details
Set a bound Microsoft Access form field to the current time when the form opens.

- 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.
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.
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.
Right-click the form in the Navigation Pane and select Design View. Open the Property Sheet and select Form from the selection list.
On the Event tab, find On Load, select [Event Procedure], and click the ellipsis button to open the VBA editor.
Inside the Form_Load procedure, add `Me.Controls("TimeUpdated").Value = Time()`. Replace TimeUpdated with the actual name of the bound control.
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 time only for a new record
Use the On Current event with a condition to avoid replacing values in existing records.
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.

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.




