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 >>>>>>