Hi, I'm not sure if I'm in the right place, but I need a program (or to
write one) that will allow me to assign a specific color to a given
numerical value. I have a numerical data set that I want to represent
by colored boxes--kind of like how meterologists show you the
temperature on a colored scale. Can I do this using HTML? I'm just
not sure where to get started. Any advice would be appreciated.
salad - 05 Jan 2006 16:16 GMT
> Hi, I'm not sure if I'm in the right place, but I need a program (or to
> write one) that will allow me to assign a specific color to a given
> numerical value. I have a numerical data set that I want to represent
> by colored boxes--kind of like how meterologists show you the
> temperature on a colored scale. Can I do this using HTML? I'm just
> not sure where to get started. Any advice would be appreciated.
You might want to check out this
http://www.mvps.org/access/api/api0060.htm
Now you can select a color. I doubt your concept will work with a
datasheet or continuous form but will work fine with a single form
record. You can create a text box or label and set the background to
whatever color you have selected.
If the numerical dataset is unbound, you can display many color text
boxes in the form.
If the numerical dataset is bound, you can display many color text boxes
in the form if each number is a field.
If you are datasheeting/continuous forms displaying the data you may
have a real hard time being able to show each record with different colors.
salad - 05 Jan 2006 16:19 GMT
> Hi, I'm not sure if I'm in the right place, but I need a program (or to
> write one) that will allow me to assign a specific color to a given
> numerical value. I have a numerical data set that I want to represent
> by colored boxes--kind of like how meterologists show you the
> temperature on a colored scale. Can I do this using HTML? I'm just
> not sure where to get started. Any advice would be appreciated.
Hmmmm....maybe by presenting the data in a report you can show the
colors...once they have been assigned to a number. In the OnFormat in
the Detail band you might be able to change the background for each
color. Haven't tested it out.
For assigning, you may want to create a lookup table to assign the color
values if you have a static number of colors.