Setting Focus

ekeenan81

New Member
Joined
Dec 8, 2010
Messages
39
I am hoping someone can help me here.

I have a form that when you are filling out and tabbing to the next row sometimes the cursor goes to the next row, but in some cases it will move down 3-4 rows.

If I set the focus using the open form command, should then when the user tabs, should it always go to the next row below?

Ex.

First Name

Middle Name

Last Name

Address

Address1

City


If I am in the First name text box and click tab, it might goto Middle Name, but when in Middle Name if I tab again, it goes all the way down to City as opposed to Last Name.


Thanks
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Take a look at Tab Order.

For 2007 it's under the Arrange tab on the ribbon or just right click on one the the text boxes on the option should appear
 
Upvote 0
Thanks Jeff.. that did the trick.

I have been reading up based off Access 2003, so I know a lot has changed, so I appreciate it.
 
Upvote 0

Forum statistics

Threads
1,224,585
Messages
6,179,704
Members
452,938
Latest member
babeneker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top