>>Thank Al, but it didn't help.
>>If I click into the textbox, all the rows in that column realign themselves properly. I'm thinking a workaround is to setfocus and remove focus on initialization, but that's not my preference for all the columns in my grid.
>>Hasn't anyone notice this before? I haven't seen any threads about it in my searches.
>>
>>>>If I set columns in a grid to sparse=.f. (textbox controls in each column), the alignment shifts upwards on some columns. To better explain it...the row will not uniformly align on the same line/row. The columns with characters will be skewed higher than the columns with integers/numerics.
>>>>Is there a way to fix that behavior? Is that a bug?
>>>>(I like the grid highlighting look with sparse set to false, so I'd like to fix it without change sparse back to .t.)
>>>
>>>For a textbox in a column, try setting .SpecialEffect to 1 - Plain from the default 0 - 3D.
>
>Hi Allen,
>
>I have seen this unusual grid formatting behavior when I use SQL Passthru query cursors. I always assumed it was because the cursor contents weren't created via Fox DBFs or Cursors and therefore Fox wasn't certain on the formatting. I haven't figured out a working solution yet. Sorry I can't be more help.

We'll you shouldn't have the alignment issue if you set the column's sparse settings to .t. Cursors are no different if they're SQL Passthru or locally created. Try checking your sparse setting and let me know if that's the issue for you.
I know my problem stems from the sparse setting.
I think it's unusual to not see more UT members writing about this problem. I would expect it to be an issue that was asked and answered by now.
Allen