Unanswered: Using variables to refer which textBox has to be changed
I want to use VBA sub to change a property of a textbox. I know how to change the property if I write the complete name of the textbox, but how does it works when the name depends on a variable.
I've got a few textbox's named text1, text2, text3 etc.
when I start my sub a variable i is set to a number ( for example "2")
So in that case I want to change the properties off 'text2'
I tried something like this:
Set fld = Forms![FormName].Controls![Text& i]
but no luke