>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]
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.