Modifies a cell's gridlines.

Usage

Set_Property(OLECtrlEntID, "OLE.CellGridLines[field; record]", Array)

Values

Array has the following structure:

PosNameTypeDescriptionDefault
<1>Left GridlineColorThe color of the cell's left gridline or "None" for no left gridlineAuto
<2>Top GridlineColorThe color of the cell's top gridline or "None" for no top gridlineAuto
<3>Right GridlineColorThe color of the cell's right gridline or "None" for no right gridlineAuto
<4>Bottom GridlineColorThe color of the cell's bottom gridline or "None" for no bottom gridlineAuto

Indices

IndexDescription
fieldIndex to an existing field
recordIndex to an existing record

Remarks

The CellGridLines property modifies a cell's gridline colors. To remove a gridline completely, set the one or more of the fields to "None". By default, all gridlines are set to "Auto", which uses the 3D Shadow Windows system color (usually a dark gray). You can set any gridline to any color of your choosing.

All gridlines are shared between adjacent cells. Thus, setting a cell's gridline will affects the cell adjacent to that gridline. For example, setting the bottom gridline of a cell to "None" means the top gridline of the cell below it is also "None".

Example

// Remove all gridlines 
Set_Property(@Window:".OLE_EDITTABLE", "OLE.CellGridLines[All; All]", "None":@FM:"None":@FM:"None":@FM:"None") 

// Set vertical gridlines only 
Set_Property(@Window:".OLE_EDITTABLE", "OLE.CellGridLines[All; All]", "3DFace":@FM:"None":@FM:"3DFace":@FM:"None") 

// Set horizontal gridlines only 
Set_Property(@Window:".OLE_EDITTABLE", "OLE.CellGridLines[All; All]", "None":@FM:"Black":@FM:"None":@FM:"Black")
  • No labels