>>>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