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