>Can I make text field in Grid column display only partial value of field (I need LEFT(field,3)) from table that is control source?
Yes, but then you would not be able to edit this field - the column will become read-only.
You can set controlsource of the column to be
(left(myTable.MyField,3))
in the Properties.
If it's not broken, fix it until it is.
My Blog 
