BLeslie88
B Leslie
- Local time
- Today, 23:47
- Joined
- May 9, 2002
- Messages
- 228
Alright, I have searched and searched, found alot of examples and guidelines for arrays and their existance and non existance in access...
I need to change properties of 1500 text boxes...
100 X 15 ...
This is an entry screen and the formatting changes depending on the selection, being the best way to explain it... A mask.
Company A : Sends 10 fields of data for a given retailer. Each field needing formatting and writing to a table their after.
Company B : Sends 13 fields, not in same order, and of course requiring diferent formatting for dif fields...
So one can see the advantage of formatting the properties using arrays.
Looping through controls.... Here is my code.
Dim cntr1 As Long
Dim Ctrl1 As Control
cntr1 = "123"
Ctrl1 = Me.Controls("Text" & cntr1)
Now, this code doesn't work, I get runtime error. Help please. With new code or ideas why this may not work...
I need to change properties of 1500 text boxes...
100 X 15 ...
This is an entry screen and the formatting changes depending on the selection, being the best way to explain it... A mask.
Company A : Sends 10 fields of data for a given retailer. Each field needing formatting and writing to a table their after.
Company B : Sends 13 fields, not in same order, and of course requiring diferent formatting for dif fields...
So one can see the advantage of formatting the properties using arrays.
Looping through controls.... Here is my code.
Dim cntr1 As Long
Dim Ctrl1 As Control
cntr1 = "123"
Ctrl1 = Me.Controls("Text" & cntr1)
Now, this code doesn't work, I get runtime error. Help please. With new code or ideas why this may not work...