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?
Speak using soft and sweet words in case you have to eat them later.