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:
>>
>>
>>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?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.