Here's the times for setting 450 textboxes' values with two methods:
a) binding textboxes : 3500 - 4000 ms
VB Code:
'code like this for i = 0 to X set text1(i).datasource = rst.fields(i) text1(i).datafield = rst.fields(i).name next i
b) setting the text manually: 70 - 80ms
VB Code:
'code like this for i = 0 to X text1(i).text = rst.fields(i).value next i
bye bye to bound controls...
regards,
Helger




Reply With Quote