Curious: Table Field Color

[Randomblink]

I play a game called Neverwinter Nights.
It is a video role-playing game.
It allows you to script and design entire worlds.

I am trying at this moment to build a database to track the MANY MANY objects and articles that a builder needs to keep track of.

Well, one of the apps in the game allows you to build an 'Area' or a plot of land (indoors / outdoors). I am trying to setup a table to track all the important information for 'Areas'. Well, one of those things you can set for an area is called:

Sun - Ambient Color

Now this is NOT the ONLY color setting, so however I setup this ONE field, will be how I set up ALL the other color related fields.

I am trying to figure out how to store color data?
I am not currently aware, but will soon be, how their colors are stored and handled, whether they are RGB Amounts or whatever... BUT I figured I would ask, just in case anyone has dealt with similar table design issues before... AND because I almost think this will be a number/text field with a Textbox/Combobox custom designed to display the colors but log the numbers.

I just wanted to ask...
Thanks...

 

[fuzzygeek]

Just a thought

Recently someone on these forums posted two color sites: one shows the color in RGB and in hex. The other shows hex. For the hex only one value (text) stored in the table. The other with the RBG has three stored as long. The RGB can be used with the RGB function in VBA. The two sites are:

(This site also shows the ACCESS number codes)
http://endprod.com/colors/

and

http://www.htmlprimer.com/colors.shtml