>>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.
>>
>
>txt.ControlSource = '=LEFT(' + myField + '),240))'
>
>
>BTW you missed a comma[)1] -> [),1]
It does let me use it, but doesn't seem to work. E.g. the value is not showing.
If it's not broken, fix it until it is.
My Blog