Need a VB code to change font color of a text based based on value
This is in access, and I have a text box which looks up a certain value for a record, and the value will either be a 1 or 2, and then the text box displays some corresponding text.
Now, I would like to find some code where if the value is a 1, i can make it red, and if it is a 2, i can make the text green. Can text box text color be changed like that? This is access 97, so rich text boxs are not allowed (to my knowledge)