I can't figure out what order controls are 'looped' through when I loop through them on an Access form.

In my specific example I'm hiding some controls and setting the TabIndex property on others when a user clicks a button.

I want the TabIndex property to correlate with the left-right order in which the controls appear on the form.  When I loop through the contols (For each ctl in me.controls...) they aren't returned in an order that I can determine.  I know it's not alphanumeric by control name.  I've named the controls PH1, PH2Average, PH3Min, PH4Max and the like which corresponds with their left to right order.
jbpowellAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 The loop is in the order the controls were added (by ordnail).

JimD.
0
 
jbpowellAuthor Commented:
Crud...is that ordinal data stored in a control property that I can modify?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Crud...is that ordinal data stored in a control property that I can modify?>>

  No.  Once it's set, that's it.  Why do you want to go through the controls in a specific way?  Maybe I can suggest something else.

JimD.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.