That was quick and correct! Thanks Martin. I can't believe I overlooked that.


>Hi Tracy
>
>These rows are dangers if fields contain .NULL. value.
>Add NVL() for removing .NULL. values.
>
>

>.Column2.CONTROLSOURCE = "(ALLTrim(Last) + IIF(!EMPTY(LAST) AND !EMPTY(FIRST),', ','')  + ALLTRIM(First) + IIF(!EMPTY(MIDDLE),' ' + ALLTRIM(Middle),'') + IIF(!EMPTY(Title), ' / ' + ALLTRIM(TITLE),''))"
>.Column8.CONTROLSOURCE = "(ALLTRIM(addr_1)+' '+ALLTRIM(apt_room))"
>END
>

>
>MartinJ
>
>>Grid sits on a page in a pageframe. This form has numerous pages and almost every page has a grid on it. The grid is loaded when the page is activated. This works on all pages except for one. On one page, the layout of the grid is not the same as the layout of the cursor that is created. To handle this, the grid properties are set in the page.activate() after the cursor is created. For some reason, if there is more than one record in the cursor, only the first record is displayed and when you click on the grid to select it and press down arrow (even though only one record is visible) a C5 error occurs. The line in the vfp9err.log is the read events line in the main.prg There is code in the afterrowcolchange of the grid but the code is identical to the other grids. It appears to have something to do with the fact that the 2nd record does not display in the grid, but if I slap a generic grid on the form, then the 2nd record displays until I run the code in the page activate
>which
>> sets the grid's properties. Any ideas anyone?