UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Conditional Format Custom Color, Access 2010    
 
   
Caseythepenguin
post Sep 15 2019, 05:39 PM
Post#1



Posts: 2
Joined: 11-September 19



I am using Access 2010 and I have setup a continuous form. I have used the conditional formatting and have set a text box rule using a custom color, but I did not write down the RGB values for the custom color. If I go back and try to edit the rule to see the color, my custom color is not showing. I want to use the same colors in other forms but without knowing the custom color values I am lost. Does Access store those values in a hidden table or can I write code in vba to get those values?

Thanks
Go to the top of the page
 
 
Start new topic
Replies
Caseythepenguin
post Sep 16 2019, 05:11 PM
Post#2



Posts: 2
Joined: 11-September 19



Thank you for your suggestions, I will give them both a try. thumbup.gif
This post has been edited by Caseythepenguin: Sep 16 2019, 05:12 PM
Go to the top of the page
 
strive4peace
post Sep 17 2019, 07:13 AM
Post#3


strive4peace
Posts: 20,464
Joined: 10-January 04



hi Casey,

more about color...

If you know an Access color number, you can break it down to its red, green, blue components

For instance, RGB(100, 150,200) = 13145700, which I will call ColorNumber

Red:
? ColorNumber mod 256
100

Green:
? int((ColorNumber mod 65536) / 256)
150

Blue:
? int( ColorNumber /65536)
200

if you have a hex value, which is 6496C8 for this example, and specified as #6496C8 on the property sheet, you can convert each couple from Hex to Long using CLng("&H" & HexValue) or to integer using CInt("&H" & HexValue) ... you can also use Int

Red:
?CLng("&H64") = 100
Green:
?CLng("&H96") = 150
Blue:
?CLng("&HC8") = 200

Another thing you can do is copy a color number to the color property of a control. Then, go to the color builder and look at what results for red, green, and blue



This post has been edited by strive4peace: Sep 17 2019, 07:21 AM

--------------------
have an awesome day,
crystal
Go to the top of the page
 
jleach
post Sep 17 2019, 07:53 AM
Post#4


UtterAccess Administrator
Posts: 10,236
Joined: 7-December 09
From: St. Augustine, FL


In addition, I find this website to be a superb reference for color-related information (including complimentary colors, etc):

https://www.color-hex.com/color/2e3f4c


--------------------
Jack D. Leach
Founder & CEO
Dymeng Services Inc.
Business Software Solutions
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    22nd November 2019 - 12:27 AM