page control 1

[rlf1957]

I have a 3 page form with buttons to move to the different pages. IT works great except that when tabbing thru the fields during data entry, the form scrolls up after the last field is tabbed thru.

Is there any way to prevent this scrolling when the last field on a page is reached ? I believe I have seen this discussed here but can't seem to locate it.

Thanks,
RLF1957

 

[Eupher]

Yeah, it's been covered, but like you, I can't seem to quickly put my fingers on a good thread. Anyway, seems like you want to disable the normal behavior of the <Tab> key in the last field. To do that, you must trap the keystroke. First, set the Key Preview property of the form to "yes." Then in the KeyDown event of the last field on your form, put in code like this:

If KeyCode = vbKeyTab Then
    KeyCode = 0
End If

HTH

Ken S.

 

[rlf1957]

Thanks, Eupher .....

That did the trick perfectly.
Sorry it took so long to get back to you - this is a part time endeavor.

RLF

 

[Eupher]

No problem, glad it worked out for you.

Ken S.