Hey, Is there any way to name the text box like "Contract (1)" I can write it this way but it is recognized as Me.Contract_1_. I need to name it Contract(1) as I have to run some iteration in VBA. Any idea?
Thanks
Hey, Is there any way to name the text box like "Contract (1)" I can write it this way but it is recognized as Me.Contract_1_. I need to name it Contract(1) as I have to run some iteration in VBA. Any idea?
Thanks
There is no need to use parens in a text box name. Names are not critical to users, make the names without special characters.
The only one that cares about the exact name is the Access program. Users can look at the caption. The dont know what the box name is.
Rename the text box to Contract, or txtContract.
Thank you ranman for your reply. I used the parenthesis to link it to run a for loop in vba. Like:
For i= 1 to 5
If Contract (i) = 1 Then
D(i) = y.Range("A" & i).Value
End If
Next i
I think in VBA this is the right way to store data in each loop.
Also possible without parens:
for each ctl in controls
if ctl.type = "TextBox" then ctl = range.value
next
I dont think this will serve my purpose. So, there is no way I can name it with a parenthesis?