no data in field then goto

[hullstorage]

hi
what is the on exit event code
so that if there is no data in field then goto another field
instead of tabbed field

regards
simon

 

[Banana]

OnExit event is rarely used; I've yet to actually use it myself. It fires whenever you try to leave the field by clicking on another control on the same form.

Basically you want to skip a field if it's blank when you're tabbing through the fields?

I wouldn't recommend that as this will make data entry a pain in ass (suppose I wanted to fill in that field but I'm forced to the next field?), but using GotFocus event, you can pass the focus to the next control of your choosing:

Me.MyNextControlName.SetFocus