property Items.CellBold([Item as Variant], [ColIndex as Variant]) as Boolean

Retrieves or sets a value that specifies whether the cell should appear in bold.

 TypeDescription 
   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.