Glad you got it working.

>We have a winner!!!! Thanks very much. I needed to put the expression in the controlsource of the column. Did that and it works perfectly now. Thanks again.
>
>>Try putting the expression in the controlsource of the column. If that doesn't work, try adding an extra set of parentheses to your expression.
>>
>>Scott
>>
>>>Maybe it's the function then?
>>>
>>>I put in the example below and it gave me the error, "The data source for this object must be a variable reference"
>>>
>>>>Colin,
>>>>
>>>>I tried placing a concatenated value in the controlsource of a one column grid with an edit box and it seemed to work for me. What problem are you having with it?
>>>>
>>>>Scott
>>>>
>>>>>I have a grid with only one column that contains an editbox. I want to display a concatenated value in the editbox like the following:
>>>>>
>>>>>

>>>>>ALLTRIM(s_iep_exemption_v.subexemp) + ' ' + ;
>>>>>ALLTRIM(s_iep_exemption_v.SubCourse) + ;
>>>>>IIF(ALLTRIM(s_iep_exemption_v.SubExemp) = "Substitution", ' for ' + ;
>>>>>ALLTRIM(s_iep_exemption_v.ForCourse), '') + ': ' + s_iep_exemption_v.Rationale
>>>>>

>>>>>
>>>>>I can't put this in the .ControlSource. Any ideas how to accomplish this?