

#VISUAL BASIC DATA GRID CONTROL WINDOWS#
MSDATGRD.OCX not registered problem in Windows 7/10 OForeColor As Long, oBackColor As Long, _Īs you can see from the event signature, you can change the text color, background color and even font for any cell or the whole row in one event handler on-the-fly. Here is an example in which we highlight cells with values greater than or equal to 50'000 with the red color in the Sum column: Private Sub iGrid1_CellDynamicFormatting( _īyVal lRow As Long, ByVal lCol As Long, _ iGrid has a similar tool (cell format strings), but it also gives you much more control over the look of individual cells or rows with the dynamic formatting events CellDynamicFormatting or RowDynamicFormatting. So you need to redistribute one more library with your end-user app and register it on client computers to make the whole system work.Īnother restriction of this way of formatting is that it can be applied only to the whole column. If you used this approach, you already know that StdDataFormat is defined in a separate DLL, MSSTDFMT.DLL, but not in the DataGrid OCX file MSDATGRD.OCX.

The VB6 DataGrid control provides you with the ability to use the StdDataFormat object to format its columns dynamically - see, for instance, the following resource: IGrid has a very rich set of events to control the user's activity. You can sort DataGrid just by clicking its column headers.ĭataGrid does not implement checkbox and combobox cell editors, but iGrid does.Ĭell text can be multiline and/or use other formatting options. You can format cells with colors and fonts. As you can see from this screenshot, iGrid surpasses VB6 DataGrid in the following functionality:
