Text Box boarder color

[Dick7Access]

Is it possible to dynamically change the boarder color of a text box when it has data?

 

[Deleted member 147267]

AFAIK, 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?

 

[Dick7Access]

AFAIK, 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 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.

 

[Uncle Gizmo]

Is it possible to dynamically change the boarder color of a text box when it has data?

Yes! See previous thread here:-

https://r.tapatalk.com/shareLink/to...&share_fid=51301&share_type=t&link_source=app


Counting non empty textboxes


where I provide a sample database and a video explaining what's going on...



Sent from Newbury UK

 

[Uncle Gizmo]

I also put the Video and download on my website here:-

https://www.niftyaccess.com/loop-through-a-set-of-controls/

Sent from Newbury UK

 

[Deleted member 147267]

You didn't inform what type of form it is. This cannot work for a data sheet, and IIRC cannot work in a continuous form either. CF can work in a continuous form but as I mentioned, not border colour. Before you trot off implementing code at the linked post (wow, some of it is verbose IMHO) you should consider the form type involved.

 

[theDBguy]

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.

Hi. Just in case it helps, take a look at this article. Good luck!

 

[Dick7Access]

Hi. Just in case it helps, take a look at this article. Good luck!

In a quick glance looks like just what I need. Thanks

 

[theDBguy]

In a quick glance looks like just what I need. Thanks

Hi. You're welcome. We're all happy to assist. Good luck. Let us know if you get stuck.

 

[Deleted member 147267]

Full circle. Setting the background colour was mentioned in post 2...