Code to stop user exiting a text box if null

[netsmurph]

Is there any sensible way to stop a user from leaving a text box null, have tried it on exit, but will not set the focus back there.

One work around is to set the on enter procedure to make the check on every other control on the form, but this seems far too long winded!

Anyone got any gems?

Many thanks

Andrew

 

[dk87]

How about checking the length on lostfocus?

 

[netsmurph]

Have tried it but it wont work, i can get it to work by setting the focus to another control and then back, ie:

If IsNull(Me.Text1) Then

Me.Text3.SetFocus
Me.Text1.SetFocus

End If

Can you see any better way to do it?

 

[dk87]

Did you try me! rather than me. ?

 

[netsmurph]

no, whats the difference?

 

[netsmurph]

have tried it and does not work