- Local time
- Today, 17:19
- Jun 9, 2009
Is it possible to dynamically change the boarder color of a text box when it has data?
Yes SURELYAFAIK, only with vba. Conditional Formatting can do fore and background colour, enable/disable and font formatting.
EDIT - and that can depend on what type of form the control(s) is/are on. Surely though you are not wanting a visual clue that a control has data?
Yes! See previous thread here:-Is it possible to dynamically change the boarder color of a text box when it has data?
Hi. Just in case it helps, take a look at this article. Good luck!Yes SURELY
I thought if I could change the color of the text box border to a brighter color in a form when it has data it would draw the eye of the reader to that line while the text box with no data would be a dull color.