On change event

[StefanSch]

Hello

Does the "on change event" in a form's text box only work if the user changes the data in the text box manually or also if the data in the text box is changed based on a formula?

Thanks.

Stefan

 

[PaddyIrishMan]

It should also work when changed via a formula.
Add code to the change event & then trigger it manually, the code should fire twice.

 

[Pat Hartman]

Read the entire help entry carefully before using the Change event. It fires for every character typed into the field for one thing so anything you do will be executed for each character that the user enters. Plus it doesn't always fire when modified by other methods. You need to explicitly referenct a control's .text property. From help:

Setting the value of a control by using a macro or Visual Basic doesn't trigger this event for the control. You must type the data directly into the control, or set the control's Text property.