Value Property (Style)
This property returns the name of a style object.
style.Value= variant
Read/Write at run time (with restrictions). Not available at design time.
Property applies to Style object.
For style objects, the Value property is a synonym for the Name property, so the following statements are equivalent:
Debug.Print TDBList1.Styles(0)
Debug.Print TDBList1.Styles(0).Name
For style objects that are members of the Styles collection, this property is read-only, and a trappable error will occur if you attempt to set it in code. However, for independent style objects, and for arguments passed to the FetchCellStyle, FetchCellTips, and FetchRowStyle events, the Value property may be set in code to initialize the style object:
CellStyle.Value = "MyStyle"
CellStyle = "MyStyle" ' Both statements are equivalent
Note: For an independent style object, the Value property always returns an empty string. An independent style object is not a member of the Styles collection, but is a standalone object created in code with a Dim or Set statement using the New keyword.
See Also