Setting form control forecolor programmatically

[Ken Warthen]

In Access 2007 VBA how would I set the value for the forecolor of a control
to the equivalent of the color represented by #204D89?

Me.MyControl.ForeColor = ?

Ken Warthen
(e-mail address removed)

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

Try

Me.MyControl.ForeColor = 8998176

In Access 2007 VBA how would I set the value for the forecolor of a control
to the equivalent of the color represented by #204D89?

Me.MyControl.ForeColor = ?

Ken Warthen
(e-mail address removed)

 

[Ken Warthen]

Boyd,

Thanks for the help. That certainly appears to be the correct color. Can
you tell me how you determined the numeric equivalent value of #204D89?

Ken

 

[Douglas J. Steele]

?RGB(CDec(&h20), CDec(&h4D), CDec(&h89))
8998176

 

[Ken Warthen]

Doug,

Thanks for the help. That's a very handy thing to know.

Ken

 

[Douglas J. Steele]

You can also go the other way, should you need to:

?Hex(8998176 And 255)
20
?Hex(8998176\ 256 And 255)
4D
?Hex(8998176 \ (256&*256&) And 255)
89

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

Doug,

Thanks for jumping it.

Boyd

You can also go the other way, should you need to:

?Hex(8998176 And 255)
20
?Hex(8998176\ 256 And 255)
4D
?Hex(8998176 \ (256&*256&) And 255)
89

Doug,

[quoted text clipped - 25 lines]