By: Yaron Goali (WISERBIT DOT COM) for Microncode.com
User Control: cGrid
Attribute | Value |
Description | Gets/sets whether the grid is in Virtual Mode (i.e. rows are added as required via the RequestRow and RequestRowData events). |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bAddRowsOnDemand | Boolean |
Attribute | Value |
Description | Gets/sets whether the header shows a grouping box to drag header items into. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | value | Boolean |
Attribute | Value |
Description | Gets/sets the background colour to use when rendering alternate rows. Set to -1 to use the standard back colour. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | oColor | OLE_COLOR |
Attribute | Value |
Description | Gets/sets the background color of the grid. |
Property Browser Page | ,Property Category |
Procedure ID | BackColor |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | oColor | OLE_COLOR |
Optional | ByVal/ByRef | Variable | Datatype |
sPic | StdPicture |
Attribute | Value |
Description | Gets/sets a picture to be used as the grid's background. |
Property Browser Page | ,Property Category |
Attribute | Value |
Description | Gets/sets the height of the background picture. |
Property Browser Page | ,Property Category |
Attributes | Don't show in property browser |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lHeight | Long |
Attribute | Value |
Description | Gets/sets the width of the background picture. |
Property Browser Page | ,Property Category |
Attributes | Don't show in property browser |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lWidth | Long |
Attribute | Value |
Description | Gets/sets the border style for the control. |
Property Browser Page | ,Property Category |
Procedure ID | BorderStyle |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | eStyle | ECGBorderStyle |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets an object representing a cell in the grid. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByRef | cG | cGridCell |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets/sets the background colour for a cell. Set to -1 to make the cell transparent. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByVal | oColor | OLE_COLOR |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets/sets the extra icon for a cell. This icon will always appear in the leftmost position for the cell. Set CellExtraIcon to -1 to remove an icon. CellExtraIcons represent ImageList icon indexes and run from 0 to Count-1. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByVal | lIconIndex | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets/sets the font to use to draw a cell. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByVal | sFnt | StdFont |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets/sets the foreground colour to draw a cell in. Set to -1 to use the default foreground colour. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByVal | oColor | OLE_COLOR |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets the text of a cell with any formatting string applicable to the cell's column applied. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets/sets the icon for a cell. If the cell has an icon set via the CellExtraIcon property, this icon will appear after it. Set CellIcon to -1 to remove an icon. CellIcons represent ImageList icon indexes and run from 0 to Count-1. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByVal | lIconIndex | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets/sets the horizontal indentation of a cell from the cell's border. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByVal | lIndent | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets/sets a long value associated with the cell. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByVal | lItemData | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets/sets whether a cell is selected or not. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByVal | bState | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets/sets the text associated with a cell. This property is a variant allowing you to store Numbers and Dates as well. In columns which are not visible, it could also be used to store objects. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByVal | sText | Variant |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets/sets the alignment and formatting properties used to draw cell text. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByVal | eAlign | ECGTextAlignFlags |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant |
Attribute | Value |
Description | Gets/sets the alignment used to draw the column header for a column. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant | |
ByVal | eAlign | ECGHdrTextAlignFlags |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant |
Attribute | Value |
Description | Gets/sets whether the specified column has fixed width or not. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant | |
ByVal | bState | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant |
Attribute | Value |
Description | Gets/sets a format string used to format all text in the column. Format strings are the same as those used in the VB Format$ function. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant | |
ByVal | sFmtString | String |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant |
Attribute | Value |
Description | Gets the order the column appears at in the column grouping. If the column is not grouped, then returns 0. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant |
Attribute | Value |
Description | Gets/sets the text to appear in a column header. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant | |
ByVal | sHeader | String |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant |
Attribute | Value |
Description | Gets/sets the image index to show in a column's header. Image indexes are 0 based indexes of the images in an ImageList. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant | |
ByVal | lImage | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant |
Attribute | Value |
Description | Gets/sets whether images (if any) will be shown on the right or not in a column header. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant | |
ByVal | bState | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | sColumnKey | String |
Attribute | Value |
Description | Gets the index of the column with the specified key. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant |
Attribute | Value |
Description | Gets/sets whether the specified column is grouped in the control. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant | |
ByVal | bIsGrouped | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant |
Attribute | Value |
Description | Gets whether this column is the row text column for the grid. The row text column must be the last column in the grid. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant |
Attribute | Value |
Description | Gets/sets the key for column. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant | |
ByVal | sKey | String |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant |
Attribute | Value |
Description | Gets/sets the order of a column in the control. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant | |
ByVal | lOrder | Long |
Attribute | Value |
Description | Gets the number of columns in the grid, including hidden and RowText columns. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant |
Attribute | Value |
Description | Gets/sets a variable which you can use to store the current column sort order. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant | |
ByVal | eSortOrder | ECGSortOrderConstants |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant |
Attribute | Value |
Description | Gets/sets a variable which you can use to store the current column sort type. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant | |
ByVal | eSortType | ECGSortTypeConstants |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vColumn | Variant | |
ByVal | sTag | String |
Attribute | Value |
Description | Gets/sets a tag string associated with a column in the grid. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant |
Attribute | Value |
Description | Gets/sets whether a column will be visible or not in the grid. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant | |
ByVal | bState | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant |
Attribute | Value |
Description | Gets/sets the width of a column in the grid. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant | |
ByVal | lWidth | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lHeight | Long |
Attribute | Value |
Description | Gets/sets the height which will be used as a default for rows in the grid. |
Attribute | Value |
Description | Gets/sets whether icons are drawn disabled when the control is disabled. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Gets/sets whether a focus rectangle (dotted line around the selection) will be shown. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bDraw | Boolean |
Attribute | Value |
Description | Gets/sets whether the grid will be editable (i.e. raise RequestEdit events). |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Returns the index of the column currently being edited, if any. |
Attribute | Value |
Description | Returns the index of the row currently being edited, if any. |
Attribute | Value |
Description | Gets/sets whether the grid is enabled or not. Note the grid can still be read when it is disabled, but cannot be selected or edited. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Determines the ideal height required to display all the cell's text in a cell. This property is only of any use if the Cell's CellTextAlign property allows multiple lines. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
Optional | ByVal | bForceNoModify | Boolean(True) |
Attribute | Value |
Description | Determines the ideal width required to fully display text in a cell. |
Attribute | Value |
Description | Gets/sets the font used by the control. |
Property Browser Page | ,Property Category |
Procedure ID | Font |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | sFont | StdFont |
Attribute | Value |
Description | Gets/sets the foreground color used to draw the control. |
Property Browser Page | ,Property Category |
Procedure ID | ForeColor |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | oColor | OLE_COLOR |
Attribute | Value |
Description | Gets the colour used to draw fill grid lines. Set to -1 to use the default grid line colour. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | oColor | OLE_COLOR |
Attribute | Value |
Description | Gets/sets the colour used to draw grid lines. |
Property Browser Page | ,Property Category |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | oColor | OLE_COLOR |
Attribute | Value |
Description | Gets/sets the grid line mode. The mode can either be standard, in which grid lines are only drawn around cells, or fill, in which case the grid lines fill the control. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | eMode | ECGGridLineMode |
Attribute | Value |
Description | Gets/sets whether grid-lines are drawn or not. |
Property Browser Page | ,Property Category |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Gets/sets the text shown in the column header grouping box when no column headers are grouped. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | sText | String |
Attribute | Value |
Description | Gets/sets the colour of the column grouping area. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | oColor | OLE_COLOR |
Attribute | Value |
Description | Gets/sets the colour used to fill the gutter to the near side of a row which is indented in a group. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | oColor | OLE_COLOR |
Attribute | Value |
Description | Gets/sets the background colour for grouping rows. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | oColor | OLE_COLOR |
Attribute | Value |
Description | Gets/sets the foreground colour of the text in grouping rows. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | oColor | OLE_COLOR |
Attribute | Value |
Description | Gets/sets whether the grid has a header or not. |
Property Browser Page | ,Property Category |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Gets/sets whether the grid's header has clickable buttons or not. |
Property Browser Page | ,Property Category |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Gets/sets whether the grid's header columns can be dragged around to reorder them. |
Property Browser Page | ,Property Category |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Gets/sets whether the header is rendered with a flat style or not. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Gets/sets the height of the header. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lHeight | Long |
Attribute | Value |
Description | Gets/sets whether the grid's header tracks mouse movements and highlights the header column the mouse is over or not. |
Property Browser Page | ,Property Category |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
vThis | Variant |
Attribute | Value |
Description | Gets/sets an ImageList to associate with the Header control. By default, the ImageList associated with the control is used. |
Attribute | Value |
Description | When AllowGrouping is True, Gets/sets whether the drag-drop area for grouping rows is hidden. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | value | Boolean |
Attribute | Value |
Description | Gets/sets the background colour of highlighted cells. Set to -1 to use the default. |
Optional | ByVal/ByRef | Variable | Datatype |
oColor | OLE_COLOR |
Attribute | Value |
Description | Gets/sets the foreground colour of highlighted cells. Set to -1 to use the default. |
Optional | ByVal/ByRef | Variable | Datatype |
oColor | OLE_COLOR |
Attribute | Value |
Description | Gets/sets whether icons in selected cells will be highlighted using the selection colour. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bHighlight | Boolean |
Attribute | Value |
Description | Gets the current Hot column (or 0 if no hot column) when HotTrack is True. |
Attribute | Value |
Description | Gets the current hot row (or 0 if no hot row) when HotTrack is True. |
Attribute | Value |
Description | Gets/sets whether the grid cells are hot tracked with the mouse. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Gets the Window handle of the control. |
Optional | ByVal/ByRef | Variable | Datatype |
vThis | Variant |
Attribute | Value |
Description | Sets an ImageList as the source of icons for the control. The ImageList can be either a VB ImageList, a vbAccelerator ImageList or an API hIml handle. If it is a VB Image List, the Image List must have had at least one icon in it before using this prop |
Property Browser Page | ,Property Category |
Attribute | Value |
Description | Gets whether the control is currently in Edit Mode. |
Attribute | Value |
Description | Gets/sets the column in the grid to be used for automatic searching when the grid is not being edited. Set to 0 to prevent automatic searching. |
Attributes | Don't show in property browser |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lCol | Long |
Attribute | Value |
Description | Gets/sets whether multiple grid cells or rows can be selected or not. |
Property Browser Page | ,Property Category |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Returns a new cell object. This can be used to set the attributes of a cell added using the Cell property. |
Attribute | Value |
Description | Gets/sets the highlight background colour for cells when the grid is out of focus. Use -1 for the default colour. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | oColor | OLE_COLOR |
Attribute | Value |
Description | Gets/sets the highlight foreground colour for cells when the grid is out of focus. Use -1 for the default colour. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | oColor | OLE_COLOR |
Attribute | Value |
Description | Gets/sets whether horizontal grid lines should be supressed when grid lines are on. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Gets/sets whether vertical grid lines should be supressed when grid lines are on. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Gets/sets the object which implements the IGridCellOwnerDraw interface for this grid, or Nothing if there is no owner draw implementation. |
Optional | ByVal/ByRef | Variable | Datatype |
impl | IGridCellOwnerDraw |
Optional | ByVal/ByRef | Variable | Datatype |
impl | IGridCellOwnerDraw |
Attribute | Value |
Description | Gets/sets whether the grid is redrawn in response to changes. Set to False whilst setting many properties to increase speed. Setting to True after it has been False forces a re-draw of the control. |
Property Browser Page | ,Property Category |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long |
Attribute | Value |
Description | Gets the grouping level of the specified row if the row is a group row. The grouping level specifies how far this group row is indented, with level 1 being the first group, 2 being the second and so on. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long |
Attribute | Value |
Description | Gets/sets the state (expanded or collapsed) for a grouping row. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | eState | ECGGroupRowState |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long |
Attribute | Value |
Description | Gets/sets the row at which the grouped column's cells start drawing. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lColumn | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long |
Attribute | Value |
Description | Gets/sets the height of a row in the grid. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lHeight | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long |
Attribute | Value |
Description | Gets/sets whether a row should be regarded as a group row. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long |
Attribute | Value |
Description | Gets/sets a long value associated with a row. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lItemData | Long |
Attribute | Value |
Description | Gets/sets whether cells can be selected in the grid (False) or rows (True). |
Property Browser Page | ,Property Category |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Gets/sets the number of rows in the grid. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRows | Long |
Attribute | Value |
Description | Gets the index of the row text column if the grid has one, otherwise returns 0. |
Attribute | Value |
Description | Gets/sets the column that text in the RowText column will start drawing at. |
Attributes | Don't show in property browser |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lColumn | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long |
Attribute | Value |
Description | Gets/sets whether a row is visible in the grid or not. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | bState | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | eStyle | ECGScrollBarStyles |
Attribute | Value |
Description | Gets/sets the style in which scroll bars are drawn. Flat or Encarta style scroll bars are only supported in systems with COMCTL32.DLL version 4.72 or higher. |
Attribute | Value |
Description | Gets the current horizontal scroll offset in pixels. |
Attribute | Value |
Description | Gets the current vertical scroll offset in pixels. |
Attribute | Value |
Description | Gets the selected column. In multi-select mode, this is the most recently selected column. |
Attributes | Don't show in property browser |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lCol | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lIndex | Long |
Attribute | Value |
Description | Gets the column of the selected cell with the specified 1-based index. See also SelectionCount. |
Attribute | Value |
Description | Gets the selected row. In multi-select mode, this is the most recently selected row. |
Attributes | Don't show in property browser |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lIndex | Long |
Attribute | Value |
Description | Gets the row of the selected cell or row with the specified 1-based index. See also SelectionCount. |
Attribute | Value |
Description | Gets/sets whether the selection colour is alpha-blended with the background colour or not. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | In row mode; gets the number of selected rows in the grid, otherwise gets the number of selected cells in the grid. |
Attribute | Value |
Description | Gets/sets whether the selection is outlined or not. DrawFocusRectangle must be False for this to work. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Gets/sets whether the control immediately goes into edit mode on selection of a cell when in EditMode. The default is two-click edit. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Attribute | Value |
Description | Returns a reference to the sort object where grid sorting options can be specified. |
Attribute | Value |
Description | Gets/sets the index of the row to split the grid at. Set to 0 for no split. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long |
Attribute | Value |
Description | Gets/sets the height of the separator between rows before SplitRow and rows after. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lSize | Long |
Attribute | Value |
Description | Gets/sets whether the last column is stretched to fit when the control is wider than all of the visible columns. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | bState | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
Optional | ByVal | lRowBefore | Long(-1) |
Optional | ByVal | lItemData | Long(0) |
Optional | ByVal | bVisible | Boolean(True) |
Optional | ByVal | lHeight | Long(-1) |
Optional | ByVal | lGroupColStartIndex | Long(0) |
Attribute | Value |
Description | Adds or inserts a new row into the grid. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
Optional | ByVal | lMinimumHeight | Long(-1) |
Attribute | Value |
Description | Automatically sets the height of a row based on the contents of the cells. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant |
Attribute | Value |
Description | Automatically resizes a column to accommodate the largest item. |
Attribute | Value |
Description | Call to cancel an edit request when the control you are using to edit a cell looses focus. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByRef | lLeft | Long | |
ByRef | lTop | Long | |
ByRef | lWidth | Long | |
ByRef | lHeight | Long |
Attribute | Value |
Description | Gets the co-ordinates of the bounding rectangle for a cell in the grid, in twips. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Sets a cell to use the default background colour (transparent). |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Sets a cell to use the default font. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Sets a cell to use the default foreground colour (the fore colour of the control). |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
Optional | ByVal | sText | Variant |
Optional | ByVal | eTextAlign | ECGTextAlignFlags(DT_WORD_ELLIPSIS Or DT_SINGLELINE) |
Optional | ByVal | lIconIndex | Long(-1) |
Optional | ByVal | oBackColor | OLE_COLOR(CLR_NONE) |
Optional | ByVal | oForeColor | OLE_COLOR(CLR_NONE) |
Optional | ByVal | oFont | StdFont(Nothing) |
Optional | ByVal | lIndent | Long(0) |
Optional | ByVal | lExtraIconIndex | Long(-1) |
Optional | ByVal | lItemData | Long(0) |
Attribute | Value |
Description | Sets multiple format details for a cell at the same time. Quicker than calling the properties individually. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | xPixels | Long | |
ByVal | yPixels | Long | |
ByRef | lRow | Long | |
ByRef | lCol | Long |
Attribute | Value |
Description | Gets the cell which contains the given X,Y coordinates (relative to the grid) in pixels. |
Optional | ByVal/ByRef | Variable | Datatype |
Optional | ByVal | bRemoveCols | Boolean(False) |
Attribute | Value |
Description | Clears the rows from the grid, optionally removing the columns too. |
Attribute | Value |
Description | Clears the current selection in the control. |
Attribute | Value |
Description | Draws the control. |
Attribute | Value |
Description | Request the normal end of an edit operation, if any. This will fire the PreCancelEdit event which provides a wayto validate the edited data prior to the editing operation being completed. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Ensures that the specified grid cell is made visible in the control. |
Optional | ByVal/ByRef | Variable | Datatype |
ByRef | iStartRow | Long | |
ByRef | iStartCol | Long | |
ByRef | iEndRow | Long | |
ByRef | iEndCol | Long | |
Optional | ByVal | bSplitArea | Boolean(False) |
Attribute | Value |
Description | Gets the visible cell range in the grid. Cells that are partially displayed are included in the range. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | sFile | String |
Attribute | Value |
Description | Loads data from a grid that was previously saved using SaveGridData. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | vKey | Variant |
Attribute | Value |
Description | Permanently removes a column from the grid. If all columns are removed, the grid will be cleared. If you want to temporarily remove a column, use the ColumnVisible property. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long |
Attribute | Value |
Description | Deletes a row from the grid. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | sFile | String |
Attribute | Value |
Description | Saves the grid's data using an internal format. The data can be reloaded into a grid with the same columns using LoadGridData. |
Attribute | Value |
Description | Populates the headers in the control based on the columns in the grid. Called automatically by the control when Headers is set to True. |
Attribute | Value |
Description | Sorts the grid data according to the options set up in the SortObject. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Attribute | Value |
Description | Starts editing on the specified cell. |
Optional | ByVal/ByRef | Variable | Datatype |
Optional | ByVal | vKey | String |
Optional | ByVal | sHeader | String |
Optional | ByVal | eAlign | ECGHdrTextAlignFlags |
Optional | ByVal | iIconIndex | Long(-1) |
Optional | ByVal | lColumnWidth | Long(-1) |
Optional | ByVal | bVisible | Boolean(True) |
Optional | ByVal | bFixedWidth | Boolean(False) |
Optional | ByVal | vKeyBefore | Variant |
Optional | ByVal | bIncludeInSelect | Boolean(True) |
Optional | ByVal | sFmtString | String |
Optional | ByVal | bRowTextColumn | Boolean(False) |
Optional | ByVal | eSortType | ECGSortTypeConstants(CCLSortString) |
Optional | ByVal | bOwnerDraw | Boolean(False) |
Attribute | Value |
Description | Adds or inserts a new column. For performance, it is best to set up columns before adding any data. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | xPixels | Long | |
ByVal | yPixels | Long |
Attribute | Value |
Description | Determines which column header is under the specified mouse point in pixels relative to the control. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | sSearchString | String | |
Optional | ByVal | bLoop | Boolean(True) |
Optional | ByVal | bVisibleRowsOnly | Boolean(True) |
Attribute | Value |
Description | Finds the first matching row for a given search string. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | iMsg | Long | |
ByVal | hWnd | Long | |
ByVal | x | Long | |
ByVal | y | Long | |
ByVal | hitTest | Long |
Attribute | Value |
Description | Moves the last row in the grid to the correct position given the current grouping and/or sorting options. |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lCol | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lCol | Long | |
ByRef | bCancel | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lCol | Long | |
ByRef | lWidth | Long | |
ByRef | bCancel | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lCol | Long | |
ByRef | lWidth | Long | |
ByRef | bCancel | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lCol | Long | |
ByRef | lWidth | Long | |
ByRef | bCancel | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | x | Single | |
ByVal | y | Single |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |
Optional | ByVal/ByRef | Variable | Datatype |
KeyCode | Integer | ||
Shift | Integer | ||
bDoDefault | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
KeyAscii | Integer |
Optional | ByVal/ByRef | Variable | Datatype |
KeyCode | Integer | ||
Shift | Integer |
Optional | ByVal/ByRef | Variable | Datatype |
Button | Integer | ||
Shift | Integer | ||
x | Single | ||
y | Single | ||
bDoDefault | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
Button | Integer | ||
Shift | Integer | ||
x | Single | ||
y | Single |
Optional | ByVal/ByRef | Variable | Datatype |
Button | Integer | ||
Shift | Integer | ||
x | Single | ||
y | Single |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByRef | newValue | Variant | |
ByRef | bStayInEditMode | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long | |
ByVal | iKeyAscii | Integer | |
ByRef | bCancel | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByRef | lItemData | Long | |
ByRef | bVisible | Boolean | |
ByRef | lHeight | Long | |
ByRef | bNoMoreRows | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | eNewState | ECGGroupRowState | |
ByRef | bCancel | Boolean |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | eBar | ECGScrollBarTypes |
Optional | ByVal/ByRef | Variable | Datatype |
ByVal | lRow | Long | |
ByVal | lCol | Long |