>>>Is there a way to dynamically assign textbox controlsource to be substr(myField,1,240)?
>>>
>>>I tried txt.ControlSource = '(substr(' + myField + ')1,240))'
>>>
>>>but got an error.
>>>
>>The only success I've had is when assigning expressions to Columns().ControlSource
>>
>>
>> This.Parent.GRid1.Columns(1).ControlSource = 'left(pp.pp, 20)'
>>
>
>Ok, never mind. Don't know why I was doing it so complicated. I simply changed txtLanguage to editbox (still keep the name) and now it all works fine.
> Don't know why I was doing it so complicated.
Well, I know why
Gregory