I have the After-Update event on a form change the text color of the font based on a number range. This works great, but when I go back into the record, because the after-update event isn't rerun, the text color reverts back to black. Does anyone know how to have the text box hold the color to red?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Change Text Color in After_Update Event - MS Access
- Thread starter dar149
- Start date
TonyJollans
Programmer
Hi dar149,
It does depend on what the criteria are (where is the number range?) but if you have A2K or above then look at Conditional Formatting.
If you have 97 or conditional fornmatting doesn't help for some reason then the OnCurrent event is where you probably need to put your code.
Enjoy,
Tony
It does depend on what the criteria are (where is the number range?) but if you have A2K or above then look at Conditional Formatting.
If you have 97 or conditional fornmatting doesn't help for some reason then the OnCurrent event is where you probably need to put your code.
Enjoy,
Tony
- Thread starter
- #3
- Status
Similar threads
- Locked
- Solved
- Locked
- Question
- Locked
- Question