Hi.

In my database, each staff member has a specific color associated with them,
which becomes a pub variable when they log on, and becomes the background
color for all of their forms, etc.

Right now, in the staff set-up table/form, I have a field that contains the
long VB color code for each user. I would like for someone who is not
necessarily familiar with these codes to be able to choos a new personal
color for a user, ideally by using something like the color picker wheel that
pops up, for example, when you are choosing colors for parts of a form in
layout mode. Except that here, obviously, I am not setting the color of the
field, but rather the value of the color number data in that field.

Does anyone know how to do this?

TIA,
Kim M.

On Fri, 3 Jul 2009 12:55:01 -0700, Kim M.
<(E-Mail Removed)> wrote:

Sure, that's quite possible using the ChooseColor windows api. Check
this out: http://www.mrexcel.com/forum/showthread.php?t=34891
This is about Excel, but it uses the same VBA that Access uses.

-Tom.
Microsoft Access MVP


>Hi.
>
>In my database, each staff member has a specific color associated with them,
>which becomes a pub variable when they log on, and becomes the background
>color for all of their forms, etc.
>
>Right now, in the staff set-up table/form, I have a field that contains the
>long VB color code for each user. I would like for someone who is not
>necessarily familiar with these codes to be able to choos a new personal
>color for a user, ideally by using something like the color picker wheel that
>pops up, for example, when you are choosing colors for parts of a form in
>layout mode. Except that here, obviously, I am not setting the color of the
>field, but rather the value of the color number data in that field.
>
>Does anyone know how to do this?
>
>TIA,
>Kim M.