>I've a grid with multiple textboxes bound to numeric fields of a view. The width of the number is 6. I'd like the user to be able to tab across the row to any column, enter any sized number, press enter or tab, exit the field to the next column. If the user pressed 'Enter' when on the last column, I'd like the focus to wrap to the next row's first numeric column. (Gosh, this sounds like I want Excel behavior...)
>
>Right now Tabbing exits the grid entirely and enter doesn't change anything. It this a case for interactive change? Am I overlooking something?
>
>Thanks.
Normally, tabbing does not exit grid. If you want to 'move' focus within the grid, you may use two things:
1) Move pointer to another recordsource record (i.e. SKIP) if you want to move to another grid row.
2) Use Column.Setfocus if you want to move to particular column.
You may intercept user's activity, e.g. pressing Enter, from Column.Textbox.KeyPress events
Edward Pikman
Independent Consultant