tutorial for ms access - common error with hiding controls

Question:
Why do I get an error when I try and programmatically hide a control? The error is "You can't hide the control that has the focus" I found a work around by setting the height and width of the control to 0, but is there a better way?

hide_control.gif (1915 bytes)

Solution:

Yes there is a better way. The reason you get this error is that the control you are trying to hide currently has focus. You have to move to another control to remove the focus and then set Command1.Visible=false.

** Bad Code **

Private Sub btnHide_Salary_LostFocus()

[Salary].Visible = False

End Sub

** Good Code **

Private Sub btnHide_Salary_LostFocus()

'Move to any other another control so that [salary] no longer has focus.

[First Name].setfocus

[Salary].Visible = False

End Sub