I never write VB code inside Access, and I am not sure how to start this, what I want to do is to color code values in an Access 2000 form based on hard-coded values in a table.
I.e. I have a table called "limits" and for each field in my form, I have a Min and a Max value, so for example, I want to color Form Field 1 red if the value in the form is below 5.0298 or above 5.0399. I have about 6 fields like this, all with different min/max range. I know I can do this directly in an Access form, but I thought it might be cleaner to do with a macro as the data is refreshed in the form and hardcoding the values in a table that is maintained and secure.
Thanks for any input,
Kai-What?
I.e. I have a table called "limits" and for each field in my form, I have a Min and a Max value, so for example, I want to color Form Field 1 red if the value in the form is below 5.0298 or above 5.0399. I have about 6 fields like this, all with different min/max range. I know I can do this directly in an Access form, but I thought it might be cleaner to do with a macro as the data is refreshed in the form and hardcoding the values in a table that is maintained and secure.
Thanks for any input,
Kai-What?