Access Search Seminar

Access Search Seminar
By Richard Rost

10 years ago

Unexpected Tabbing Behavior Upload Images Link
Michael Krailo
2 years ago

For lesson 18, as the user tabs through the search form, eventually the tab will end up on a control that is hidden due to the size of the form only. To overcome this problem, you could set the advanced controls visible property to false until the >> button is pressed. There should also be an OnOpen event that turns off advanced controls visibility as well. I havn't viewed the rest of the lessons yet so I appoligize if this is addressed further in the seminar.

Private Sub Form_Open(Cancel As Integer)
   AndOrCbo.Visible = False
   DoCmd.MoveSize , , 4000
End Sub

Private Sub AdvancedBtn_Click()
   If AdvancedBtn.Caption = ">>" Then
      AndOrCbo.Visible = True
      DoCmd.MoveSize , , 7000
      AdvancedBtn.Caption = "<<"
   Else
      AndOrCbo.Visible = False
      DoCmd.MoveSize , , 4000
      AdvancedBtn.Caption = ">>"
   End If
End Sub

Richard Rost
2 years ago

Good idea. Thanks for the tip, and the code!

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Search Seminar