MS Access Form Control Background Color Change Depending On How Long The String Text Length Is
Ok this might be a interesting one! I would like to add the ability of changing the background color of a specific text box control on my form depending on the length of text that is in it.
Normal basic color is white. White = Good!
Text string count reaches 76 character length then the background goes Yellow. Yellow = Warning!
Text string count reaches 150 character length then the background goes Red. Red = Maximum!
We like to keep it under 76 length but in some cases it can be longer!