G
Guest
Hello, I am not a new programmer (20+ year) Just new to Access 2003.
I know in some of the database applications that I have written in the past.
That I have been able to set in the code, a way to change the background
color of a query. For instance, you have a query that displays several
projects that are in the workings. The right most colums are status columns.
As each process is completed, that column is checked off to show that this
process has been completed. I have figured out how I can change the Text
color. What I need is a way to change the background color of these specific
cells as they are checked off, this would give us a graphical view of how far
into the process each of these process's this project has gone. Mostly to be
displayed on status monitors, that way the solid background of blue or green
is easier to see, than text in those fields. Is there some code that can be
placed into the field default value that will allow me to change the
backgrounds of each cell on the fly?
I know in some of the database applications that I have written in the past.
That I have been able to set in the code, a way to change the background
color of a query. For instance, you have a query that displays several
projects that are in the workings. The right most colums are status columns.
As each process is completed, that column is checked off to show that this
process has been completed. I have figured out how I can change the Text
color. What I need is a way to change the background color of these specific
cells as they are checked off, this would give us a graphical view of how far
into the process each of these process's this project has gone. Mostly to be
displayed on status monitors, that way the solid background of blue or green
is easier to see, than text in those fields. Is there some code that can be
placed into the field default value that will allow me to change the
backgrounds of each cell on the fly?