Reorder all controls in form

Hi Experts,

I'm using code

For Each ctl In Forms... to change the name of all the controls in a form.
That works fine, the problem is that the controls are in the wrong order, how do I change that? Changing the Tab Order doesn't work.

Gary
LVL 46
tbsgadiAsked:
Who is Participating?
 
Dale FyeCommented:
The controls show up in the controls collection in the order they were created, so if you want to loop through them in a specific sequence (tab order), you are probably going to have to setup a temp table to store the name of the control and the tab order.  

Then create a recordset based on that table and sorted by tab order to get them in the sequence you want them in, before doing your sequential renumbering.
0
 
tbsgadiAuthor Commented:
Thanks, I just found it easier to add the textboxes from scratch.
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.