>>>>>Jim, This form will be used by several dbfs, all with the same structures.
>>>>
>>>>After you do the d and d remove the alias from the controlsource properties. Then remove the dbf from the de.
>>>
>>>Well that's just it, the D & D x50 is ok, but removing the alias x50 could be quite cumbersome.
>>
>>Timothy,
>>
>>You would only have to do the 50 times one time though. It seems like a lot, but once you're done, you're done. Probably only take about 15 minutes really.
>>
>>Renoir
>
>Hi Renoir :)
>He shouldn't one-by-one IMHO. Select all in DE, drag with right button and select 'Create multiple controls here'.
>
>Then select any one control on form and run :
>
>
aselobj(arrForm,1)
>for each oControl in arrForm[1].Controls
> with oControl
> if upper(.Baseclass)='TEXTBOX' and !empty(.Controlsource)
> .ControlSource = substr(.Controlsource, at('.',.Controlsource)+1)
> endif
> endwith
>endfor
Cetin
Cetin, I have 50 fields, I only only visually access 18, whcih is how many can be displayed with my designer form maximized. Even if I scroll or resize! :(
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."