Displaying an RGB color in a Datasheet view based on the RBG value in the Column

[charlesben59]

We are using a data sheet view to display the content of a table of colors, we would like one of the columns to display a colour chip of the RGB value it contains,



example

Color Name RGB Value Color Chip
White 255,255,255

any trick would be appreciated

[ranman256]

use a form , not a datasheet.

[ThornofSouls]

I don't think you can change the color of a field in data sheet. However a form would be better, as ranman256 mentioned.

If you use a form instead you can always change the color of a field, font or object quite easily with a few rows code.

Me.Object_Name.BackColor = RGB(255, 255, 255)
Me.Object_Name.ForeColor = RGB(0, 0, 0)

//Thorn

[ItsMe]

If it must be in datasheet view, you can use the intrinsic 'Conditional Formatting' tool that is found under the Format tab of the Ribbon (while in design view of your form).