J John Bruen Sep 3, 2004 #1 If I change the code from on_change to lost_focus, I can update the field then.
L Larry Linson Sep 5, 2004 #2 Check Help and Documentation on when the Change event fires; IIRC, it fires with every keystroke you make in the Control, and that is probably not what you want. Larry Linson Microsoft Access MVP
Check Help and Documentation on when the Change event fires; IIRC, it fires with every keystroke you make in the Control, and that is probably not what you want. Larry Linson Microsoft Access MVP
