Change text color in a combo box

[echorley]

I have a report card program that I use in my classroom. The program calculates letter grades for various sub categories.

For example, under the Primary Category Math, the computer will calculate a letter grade based on assignment scores and place the grade into a combo box for the sub category "Able to use a graphing calculator."

If I override the grade the program calculated for a student, I would like the text in the combo box to change to red for that student only. Then I can go back and quickly see which grades I have manually changed.

I just cannot seem to figure out the logic to use VBA that would check to see if a user has changed individual combo boxes.

Thanks ahead of time for any ideas.

 

[ssteinke]

hello,

If your combo box value is a calculation performed at runtime based on data in your table, you will need an additional field in your table to indicate that you manually changed the grade.

Once you have created that field, you will then be able to have your calculation check the new field first to see if a manual change has been made, then changing the color of your combo box should be as simple as using a conditional format.

Scott

 

[echorley]

Thought of that...

I thought of that, but the Math table is pretty big considering all of the sub categories that I need and then multiply it by 4, one for each term. It is not realisitic to break the math table into 4 different tables (for each term) as it would make the grading form a mess with multiple sub-forms.

I am trying now to work with a duplicate Math table. If I manually change a combo box, it will place a "1" in the duplicate table in the appropriate location. Then at runtime, I can lookup the value in a duplicate table that corresponds to each combo box to see if there is a "1".