Tab button to jump to empty fields only

[andy49]

I have a continuous form with six controls (approx. 28 rows)




text1, text2, text3, empty, empty2,empty3

I'd like to be able to click on the first empty cell and then when the tab button is pressed, it jumps to the next empty cell.

Happy to use vba but am looking for an idea to get me started

Many thanks

Andy

[NTC]

tab order is a set form property. And then each field/control has a Tab Stop property (yes/no).

In the On Current event (which triggers when you first put your cursor into the record) - you would need a stack of vba code, 1 line per control, that resets their Tab Stop property based upon there being a value in their field.

You cannot defy the form's tab order fundamentally but you could skip over fields with values.

there could be a conflict with the 1st control on attempting to change its Tab Stop property while it is the In Focus control - such that you might need a faux 1st field just to hold the cursor temporarily - an off the cuff thought.....

[Micron]

You can trap for the tab key if KeyPreview is enabled for the form. Don't know if you can suppress cursor move if control tab stop property is true. If not, maybe set to false and use sequenced control tag values to cycle through them until an empty one is found.

[andy49]

This was actually much easier than I hoped.

https://support.office.com/en-gb/art...7-c1785a0dd438


Thanks for your input.


Sent from my iPhone using Tapatalk