Color coding data...

[Mary A Perez]

My user wishes for me to color code data entered, however not all data using
the same textboxes, etc can be the same color.
Any way to resolve this or should I tell the user we need to figure out
another way to show the data.
Basically here is what they want:
Contract related data in Black
Provider Manual related data in Blue
Other resource specific data in Red
Thank you in advance for helping.

 

[Rick B]

You can set the color for each control different. If a particular control
is related to a contract, set it to black.

Am I understanding you correctly? You have some controls on your form that
you want to be blue, some that you want to be black, some red, etc.?

If not, please give us more specifics.

 

[Mary A Perez]

The data to be entered is to be different colors, & if I change the control
for one it will be that color across all the forms.
Is there a way to enter the text/data & change it's color specifically w/o
changing the color for the control?
Not all data entered into each control will always be contract related & may
need to be another color other than black.
I hope this explains it better.
I'm not sure if this can be done, if not, I'll ask the user if we can
identify these different types of data with symbols or something else that
doesn't have to be control related.
Thanks so much for your help.

 

[Rick B]

Ahhhh. So they could make an entry in one of your controls and that entry
might be contract related? Then, they could make an entry in another
control for that SAME record and it might not be contract related? So they
want to change the colors of each control as they enter data into your form,
and each control in any given record could be one of three colors?

If so, I doubt it could be easily done, but more importantly, you would not
be able to use this data. When you run a query, you could not tell the
query to pull all records with a red entry in Field1, for example.

If, instead, you want all the controls in a given record to be the same
color, then you can simply use conditional formatting and base the color on
your "type" field. So if you pull up a record that is contract related,
every control on that particular record would be black. If you pull up a
record that is ?"other" then all the controls would be red, etc.

 

[Mary A Perez]

Thanks Rick. I appreciate your time.

Ahhhh. So they could make an entry in one of your controls and that entry
might be contract related? Then, they could make an entry in another
control for that SAME record and it might not be contract related? So they
want to change the colors of each control as they enter data into your form,
and each control in any given record could be one of three colors?

If so, I doubt it could be easily done, but more importantly, you would not
be able to use this data. When you run a query, you could not tell the
query to pull all records with a red entry in Field1, for example.

If, instead, you want all the controls in a given record to be the same
color, then you can simply use conditional formatting and base the color on
your "type" field. So if you pull up a record that is contract related,
every control on that particular record would be black. If you pull up a
record that is ?"other" then all the controls would be red, etc.