Skipping columns when tabbing on a DataGrid

It happens quite often that you have a DataGrid with hidden columns (with width = 0), because you need their values but don’t want to show them to the user. However, when you tab through the DataGrid’s columns, these “hidden” columns are still taken into account in the tab order. This means that when the user presses the Tab key the focus might seem to disappear from the DataGrid and the form, when in reality it is on the hidden cell. This behavior is not very user friendly, and may leave the user wondering what happened, and if he has to click somewhere or press Tab again. It would be much better if the Tab could skip some columns, so that everything work as if those hidden columns were not there at all. This skipping mechanism could also be useful in other situations, when you have visible columns but don’t want the user to be able to give them the focus, either by pressing Tab or by clicking directly on them. You can solve this problem by handling the DataGrid’s CurrentCellChanged event, and simulate a Tab keypress when the user selects an “inaccessible” column. Here’s the code to enable/disable the column-skipping mechanism:

' Enable the column-skipping mechanism for the input grid,'  and for the columns with the specified index' Example: skip the 2nd (index 1) and 4th (index 3) columns'   EnableDataGridColumnSkip(DataGrid1, 1, 3)Sub EnableDataGridColumnSkip(ByVal grid As DataGrid, _    ByVal ParamArray columnsToSkip() As Integer)    ' save the array of column indexes in the grid's Tag property    grid.Tag = columnsToSkip    ' attach the grid's CurrentCellChanged event to the     ' GenDataGrid_CurrentCellChanged event handler    AddHandler grid.CurrentCellChanged, AddressOf GenDataGrid_CurrentCellChangedEnd Sub' Disable the column-skipping mechanism for the input grid' Example: DisableDataGridColumnSkip(DataGrid1)Sub DisableDataGridColumnSkip(ByVal grid As DataGrid)    ' detach the grid's CurrentCellChanged event from the     ' GenDataGrid_CurrentCellChanged event handler    RemoveHandler grid.CurrentCellChanged, _        AddressOf GenDataGrid_CurrentCellChangedEnd Sub' Handle the grid's CurrentCellChanged, to skip the columns whose index is ' found in the array stored in grid's Tag propertySub GenDataGrid_CurrentCellChanged(ByVal sender As Object, _    ByVal e As System.EventArgs)    ' cast the generic sender Object to a DataGrid    Dim grid As DataGrid = DirectCast(sender, DataGrid)    ' cast the grid's Tag to an array of Integers, that contains the indexes of     ' the columns to skip    Dim columnsToSkip() As Integer = DirectCast(grid.Tag, Integer())    ' get the index of the current column    Dim currColIndex As Integer = grid.CurrentCell.ColumnNumber    ' if the current column's index is found in the columnsToSkip array,    '  simulate a TAB key press,    ' so that the focus is moved to the next column in the same row,    '  or to the next row if this is the last column    If Array.IndexOf(columnsToSkip, currColIndex) > -1 Then        SendKeys.Send("{TAB}")    End IfEnd Sub

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS