Tab Stop in forms

[data808]

I have a few menu forms that contain only buttons to open other forms. I set all the tab stop properties to No. However, I noticed that the button that has the first tab stop of 0, is the button that has the focus when the form opens. This is not good in case the user accidentally presses the Enter button on the keyboard, it will automatically click this first tab stop button on the form. Does anyone know how to prevent this from happening?

[azhar2006]

Hi ,data
use the code
Private Sub Form_Current()
Command1.SetFocus
End Sub

[data808]

Wouldn't this code make the next button get the focus? I don't want any buttons to have the focus just in case the user presses Enter on the keyboard. Let me know if I am wrong and this code is in fact what I want it to do.

Thanks so much for the help.

[Missinglinq]

I think you'll have to fool the Access Gnomes to do this!

In Form Design View

1. Create a Textbox
2. Name it FauxControl
3. Move it up to the Top/Left of the Detail Section
4. Delete the attached Label (if any)
5. With the Textbox selected, hold <Shift> down and use the Up and Left Arrows to reduce it to a pinpoint

Now, place this code in the Form's Code Module:

Private Sub Form_Load()
 FauxControl.SetFocus
End Sub

Linq ;0)>

[azhar2006]

Very nice
Missinglinq
Ha ha you are actually deceitful

[data808]

I actually did this before but considered it to be pretty ghetto. I was just wondering if access had a traditional feature to prevent this from happening. Thanks anyway.

[MarvinM]

I don't know of any other way. When the form is opened, and becomes "Current", something needs to have focus. If there are data entry fields, I always go with the first one I want the user to enter data into. If it is just a menu screen, with all buttons, I will set the focus on the "Exit" button. That way if the user accidentally hits the Enter key, no harm, they just have the form close and they wonder how they did that. Then they have to reopen the form. It doesn't take long for them to learn not to accidentally hit the Enter key anymore.

This combines safety for your form with some behaviour modification training for your users. A win-win!

[data808]

Whats funny is That idea did cross my mind as well but I think I like the trick of making a pin sized text box and setting focus to that. You can't even see the text box its so small. Anyway, thanks everyone for all the suggestions. You guys are awesome.

[Missinglinq]

...You can't even see the text box its so small...

That's correct...it's too small to be detected by the human eye!

Once again, glad we could help!

Linq ;0)>