Reset created item counter on form

[kenneth.campos]

So lets say I create 80 text boxes. They'd be auto named Text1 through Text 80. Then I delete the last 40 of them. So now I have Text1 through Text 40. If I create a new one, it becomes Text81. Is there a way to make it start with the next available (Text41) instead? Also if I create a combo or check it uses the same number (combo82, check83). So can those start at 1 for each type? I can go through and rename them all manually in the property sheet, other tab, name field, but If I can just reset the counter to the next available I'd really prefer that.

 

[JANR]

I can just reset the counter to the next available I'd really prefer that

Can't be done, I belive it's Acces way on keeping tabs on how many controls that you created on a from/report, when the limit of 754 is reached then no more controls can be made.

JR

 

[gemma-the-husky]

I would think you could fairly easily write a function to renumber all the text boxes though.

Out of interest, why do you need so many? Often a requirement for so many text boxes indicates a structure that could be improved by using a datasheet/continuous form.