I am trying to use the Common Dialog Color box to pick a color and then return it's HTML value on a MS Access form. Right now I just want a MsgBox with the color value.
Code:
Private Sub Command1_Click()
With CommonDialog
.DialogTitle = "Pick a color"
.ShowColor
Dim htmlColor As String
' htmlColor = System.Drawing.ColorTranslator.ToHtml(.Color)
MsgBox "Color is " & System.Drawing.ColorTranslator.ToHtml(.Color)
End With
End Sub
I can pick the color then I get a 424 error Object required. I am a total noobie and I know the problem is somewhere on the MsgBox line.
TIA
Caleb
using ColorTranslator