Value Property

Description

Returns/sets the current selected color.

Usage

[form.][control.]Value[ = OLE_COLOR ]

• Microsoft Access user note:

In Microsoft Access, there should use "Object" member to get an ActiveX control properties and methods, as following:

...

Control1.Object.xxxx

...

So you can get the current color value with following code line:

color = ColorPicker1.Object.Value

See also Color property.

• While EnableDefaultItem is TRUE, user maybe select a default color, default color is a special item, CAN NOT get the control straightly from Value property in this situation, to get the control current selected color as following method:

Dim who As CPWhoIsSelected, color As OLE_COLOR

who = ColorPicker1.WhoIsSelected()

If who = CPWhoIsSelected.ccDefault then

color = ColorPicker1.DefaultItemColor()

Else

color = ColorPicker1.Value()

End if

See also DefaultItemColor and WhoIsSelected property.

Data Type

OLE_COLOR

Default

&HFFFFFF(White)

Remarks

Notes: Color cells tooltip texts will not synchronize automatically after its value is changed. All color cells tooltip texts need be modify manually if you hope it has meaning, refer to SetColorCellToolTip method.

Sample

ColorPicker1.Value = &HC0FFFF