tab order

[Al]

Hi Folks,

I have a number of frames in my dialog box. Each textbox in each frame seems
to reset the tab order.

ie:


___________FRAME 1_____________

[1] [2] [3] <-textboxes tab order 1,2,3,


__________FRAME 2______________

[LISTBOX] <- no tab order


_________FRAME 3________________

[4] [5] <-textboxes order 4,5

[OK 5] <- ok btn tab order 6

__________________________________


Anyone know about this?

Cheers

-Al

 

[Peter Hewett]

Hi Al

From the VBA IDE open up your Form. Right click on the Form surface (but
NOT on a control) and select Tab Order. You should see the Frames and any
other controls you've added to the Form - but NOT the controls you've added
to the frames. Now set the tab order for the Frames and any other controls.

If at this stage your textboxes are listed as part of Form and not the
frames then you'll need to delete them and readd them correctly to the
Frame.

Repeat this step for each frame. Right click in the Frame surface (but NOT
on a control) and select Tab Order. Now set the order of the controls
within the Frame.

HTH + Cheers - Peter

 

[Al]

Yep thanks Peter - that really helped and I learnt something new.

I also noticed that it appears if you set the tab order to 0 it does not
appear on the tab order list at all?

Thanks again,

-Al

Hi Al

From the VBA IDE open up your Form. Right click on the Form surface (but
NOT on a control) and select Tab Order. You should see the Frames and any
other controls you've added to the Form - but NOT the controls you've added
to the frames. Now set the tab order for the Frames and any other controls.

If at this stage your textboxes are listed as part of Form and not the
frames then you'll need to delete them and readd them correctly to the
Frame.

Repeat this step for each frame. Right click in the Frame surface (but NOT
on a control) and select Tab Order. Now set the order of the controls
within the Frame.

HTH + Cheers - Peter

Hi Folks,

I have a number of frames in my dialog box. Each textbox in each frame
seems to reset the tab order.

ie:


___________FRAME 1_____________

[1] [2] [3] <-textboxes tab order 1,2,3,


__________FRAME 2______________

[LISTBOX] <- no tab order


_________FRAME 3________________

[4] [5] <-textboxes order 4,5

[OK 5] <- ok btn tab order 6

__________________________________


Anyone know about this?

Cheers

-Al