>>>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?
>>
>>You may want to assign it in a code...
>
>Not sure what you mean here. Can you expand? Thanks.
Actually, I'm not sure, it would work. I remember, in cases like this I use a variable. I assign this variable in form refresh...
If it's not broken, fix it until it is.
My Blog