Retrieves or sets a value that specifies whether the cell should appear in bold.
|Item as Variant||A long expression that indicates the item's handle.|
|ColIndex as Variant||A long expression that indicates the cell's handle or the column's index, a string expression that indicates the column's caption or the column's key|
|Boolean||A boolean expression that indicates whether the cell should appear in bold.|
Use the CellBold property to bold a cell. Use the ItemBold property to specify whether the item should appear in bold. Use the HeaderBold property of the Column object to bold the column's caption. Use the CellItalic, CellUnderline or CellStrikeOut property to apply different font attributes to the cell. Use the ItemItalic, ItemUnderline or ItemStrikeOut property to apply different font attributes to the item. Use the CellValueFormat property to specify an HTML caption. Use the ConditionalFormats method to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula.
The following VB sample bolds the focused cell:
With Grid1.Items .CellBold(.FocusItem, Grid1.FocusColumnIndex) = True End With
The following C++ sample bolds the focused cell:
#include "Items.h" CItems items = m_grid.GetItems(); items.SetCellBold( COleVariant( items.GetFocusItem() ), COleVariant( (long)m_grid.GetFocusColumnIndex() ), TRUE );
The following C# sample bolds the focused cell:
axGrid1.Items.set_CellBold(axGrid1.Items.FocusItem, axGrid1.FocusColumnIndex , true);
The following VB.NET sample bolds the focused cell:
With AxGrid1.Items .CellBold(.FocusItem, AxGrid1.FocusColumnIndex) = True End With
The following VFP sample bolds the focused cell:
with thisform.Grid1.Items .DefaultItem = .FocusItem .CellBold( 0, thisform.Grid1.FocusColumnIndex ) = .t. endwith
The following VB sample bolds all cells in the first column:
Dim h As Variant Grid1.BeginUpdate With Grid1.Items For Each h In Grid1.Items .CellBold(h, 0) = True Next End With Grid1.EndUpdate
Note: The intersection of an item with a column defines a cell. Each cell is uniquely represented by its handle. The cell's handle is of HCELL type, that's equivalent with a long type. All properties of Items object that have two parameters Item and ColIndex, refer a cell.
The following lines are equivalents and each of them changes the bold font attribute of the first cell on the first item.
With Grid1 .Items.CellBold(, .Items.ItemCell(.Items(0), 0)) = True .Items.CellBold(.Items(0), 0) = True .Items.CellBold(.Items(0)) = True .Items.CellBold(.Items.ItemByIndex(0)) = True .Items.CellBold(.Items.ItemByIndex(0), 0) = True .Items.CellBold(.Items(0), Grid1.Columns(0).Caption) = True End With
Send comments on this topic. © 1999-2017 Exontrol.COM, Software. All rights reserved.