Hi,

Tyr using a select to a cursor with the concatenated value?
Something like:

select 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 as NewField from s_iep_exemption_v
<pre>

Then use the resulting cursor as you source.  The controlsource then would be the 'NewField' as in above.

HTH,
Arriyel

>I thought this as well. I can do this for a single record in an editbox, but how would I do this to show multiple records in a grid?
>
>>Hi,
>>
>>Store it in a variable then use the variable as the controlsource.
>>
>>HTH,
>>Arriyel
>>
>>>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:
>>>
>>><pre>
>>>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?