As it says in the Help file, "While the control has the focus, the Text property contains the text data currently in the control; the
Value property contains the last saved data for the control. When you move the focus to another control, the control's data is updated, and the
Value property is set to this new value. The Text property setting is then unavailable until the control gets the focus again."
(Note that the line [ConsumptionPer100KMs].SetFocus is unnecessary, becuase the control will automatically have focus if the AfterUpdate event is firing: the AfterUpdate event only fires when data is keyed into the control.)
Doug Steele, Microsoft Access MVP www.AccessMVP.com/djsteele
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.