Printable View
Is there a simple way to change a text box's datafield?
Aside from making it a string and changing the string every time you want to change it?
Such as...
Text2 is set to DataField "FIELD2", I need it to switch to "FIELD3" and so on and so on. Until I get to "FIELD128". Whats the easiest way to do that?
Thanks.
Anyone know how to switch those? I've v\been tryin for a while with different combos of strings and other variables, but have yet to come up with something. Any help would be great.
Does it have to be by field name or can you do it by index?
Code:
Dim rsData as New RecordSet
' load rsData stuff here
' assuming you have 128 fields in rsData
For lngindex = 1 to 128
txtTextBox.DataField = rsData(lngIndex)
'do whatever you have to do here
Next
Just a shot in the dark since I haven't actually tried it.
I'm pretty sure it has to be by field name, I'm gonna try throwin it into an array...
I'll wish myself luck.
Thanks alot tho.