![]() Versatile data bindingĭespite the fact that iGrid works mainly in unbound mode, you can make it a data-bound control by adding some code. ![]() In addition to this, iGrid allows you to upload ADO and DAO Recordsets into it with one command and use all its rich formatting features for these data without any restrictions. Unbound mode, when you can change its cell independently, is its main work mode. IGrid is free from all the drawbacks mentioned above. And this is really annoying if you need data of different data types and/or formatting in the same column. If you decide to solve this task with the VB6 DataGrid control, first you need to load the data into a temporary interim data store and only after that bind the DataGrid to it to show your data on the screen.īut this is just a half of the problem: you cannot freely change or format your data in individual cells as they are in fact the underlying recordset fields. In other words, you need an unbound VB6 DataGrid. VB6 DataGrid allows you to upload data from a database table or query, but in many cases you also need to display data stored not in a database (in a CSV file, an array, etc). MSDATGRD.OCX problem in Windows 10 from Outlook form 2016 with VBAįrom this point of view, the iGrid control is a better VB6 DataGrid control alternative as it is implemented in one OCX file with no external dependencies. And you should do it the right way to register MSDATGRD.OCX in 64-bit Windows 7 or 10: ![]() These are COMCAT.DLL and MSSTDFMT.DLL, which must be deployed and registered with MSDATGRD.OCX too. As you already know from the previous subsection, VB6 DataGrid requires some extra files for proper functioning. When you deploy your application to client computers, you also need to redistribute and register MSDATGRD.OCX in Windows 7 or 10 properly to avoid the MSDATGRD.OCX Not Registered error. ![]() The VB6 DataGrid control is an ActiveX control implemented in the MSDATGRD.OCX file. 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:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |