I am trying to set the TabStop property in vba.
I have a textbox named "txtControl".
So, me.txtcontrol.TabStop = true morphs into me.txtControl.tabstop = True
I would expect me.txtControl.TabStop = True
Running the code does not create an error, nor does it affect the TabStop property of the control.
This indicates that vba is not recognising TabStop as a genuine property of a text box although it appears in the dropdown as "TabStop" after "me.txtControl."
How do I programmatically control the user's ability to tab into a control?
I can easily lock the control to stop changes but I need certain controls to be skipped over under certain circumstances.
Changing the TabStop property seems to be the logical way to do this.
Am I missing something in the "File - Options" window or the "Form.Load" event?
I have a textbox named "txtControl".
So, me.txtcontrol.TabStop = true morphs into me.txtControl.tabstop = True
I would expect me.txtControl.TabStop = True
Running the code does not create an error, nor does it affect the TabStop property of the control.
This indicates that vba is not recognising TabStop as a genuine property of a text box although it appears in the dropdown as "TabStop" after "me.txtControl."
How do I programmatically control the user's ability to tab into a control?
I can easily lock the control to stop changes but I need certain controls to be skipped over under certain circumstances.
Changing the TabStop property seems to be the logical way to do this.
Am I missing something in the "File - Options" window or the "Form.Load" event?