You could issue a thisform.setall() statement, but that would only be valid after all the controlsources are already bound. Look into it, though, you may find a use for it.
Otherwise, if you are just wanting to do this once, you can open the .SCX/.VCX and look for all records that has a controlsource tag in the properties field. (Make sure to backup the file first before doing this in case something goes wrong!).

For future form loads, you could specify the controlsources in the form init, since it fires after all objects are instantiated. You could also wait even longer to bind the controls or possibly bind some of them as necessary to give the impression of greater form speed. It depends upon the specific needs of the particular form.

Lastly, you could keep the table (view) in the data environment and set the NoDataOnLoad to .t. which will allow all the controls to bind to an empty table. Then later, you can populate the view. This allows your screen to load fairly quickly.

Probably more than you wanted, but I hope it helps!


>In my old design, i put the table in the data envi. and set the control source.
>Now ,as the table size is increased, the form is loaded very very slow.
>I decided to remove the table in data envi. and clear the control source.
>However, There are over 30 textbox object in one form.
>Any simple program to clear all the control source ??
>Thx a lot
>
>From Agnes