Report Background Color using VBA

[baba]

Could you please tell me how to change background color of MSAccess Reports using VBA?
How can I do border coloring. What are the vba codes for all color options like light green, light blue etc.


How to change the font type to bold etc using vba
I did some changes to text box coloring in Detail Section on format click event.
Thanks for the help !

[ItsMe]

Could you please tell me how to change background color of MSAccess Reports using VBA?...

Are you trying to use VBA to assign a specific color? You can enter RGB values and Pantone values into the Properties of controls via the Property Sheet while in design view. Once they are in the properties, you can use debug.print to understand what VBA calls a specific color. Then you can create your own enum with the results.

If you know the RGB, you could just use the RGB function. In this example RGB(5, 255, 9) = 655109

Me.cmdColorMe.ForeColor = RGB(5, 255, 9)
Debug.Print Me.cmdColorMe.ForeColor '655109

[June7]

Lots of color charts and converters on web http://rapidtables.com/web/color/RGB_Color.htm

VBA has 8 intrinsic color constants: vbBlack, vbWhite, vbRed, vbGreen, vbBlue, vbYellow, vbMagenta, vbCyan

http://excel.tips.net/T002778_Offici...es_in_VBA.html