Go Back   Access World Forums > Apps and Windows > Visual Basic

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-04-2019, 06:52 PM   #1
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,497
Thanks: 608
Thanked 41 Times in 39 Posts
Dick7Access is on a distinguished road
Text Box boarder color

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

Dick7Access is offline   Reply With Quote
Old 11-04-2019, 07:13 PM   #2
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,235
Thanks: 10
Thanked 232 Times in 220 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Text Box boarder color

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?
__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
The Following User Says Thank You to Micron For This Useful Post:
Dick7Access (11-04-2019)
Old 11-04-2019, 07:31 PM   #3
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,497
Thanks: 608
Thanked 41 Times in 39 Posts
Dick7Access is on a distinguished road
Re: Text Box boarder color

Quote:
Originally Posted by Micron View Post
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.

Dick7Access is offline   Reply With Quote
Old 11-04-2019, 07:38 PM   #4
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,365
Thanks: 555
Thanked 948 Times in 897 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Text Box boarder color

Quote:
Originally Posted by Dick7Access View Post
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/top...ink_source=app


Counting non empty textboxes


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



Sent from Newbury UK
__________________
Code:
                 |||||
               @(~‘^‘~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
The Following User Says Thank You to Uncle Gizmo For This Useful Post:
Dick7Access (11-04-2019)
Old 11-04-2019, 07:40 PM   #5
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,365
Thanks: 555
Thanked 948 Times in 897 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Text Box boarder color

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

https://www.niftyaccess.com/loop-thr...t-of-controls/

Sent from Newbury UK
__________________
Code:
                 |||||
               @(~‘^‘~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 11-04-2019, 07:45 PM   #6
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,235
Thanks: 10
Thanked 232 Times in 220 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Text Box boarder color

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.
Micron is offline   Reply With Quote
Old 11-05-2019, 08:54 AM   #7
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,628
Thanks: 58
Thanked 1,456 Times in 1,437 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Text Box boarder color

Quote:
Originally Posted by Dick7Access View Post
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!

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Dick7Access (11-05-2019)
Old 11-05-2019, 10:31 AM   #8
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,497
Thanks: 608
Thanked 41 Times in 39 Posts
Dick7Access is on a distinguished road
Re: Text Box boarder color

Quote:
Originally Posted by theDBguy View Post
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
Dick7Access is offline   Reply With Quote
Old 11-05-2019, 10:46 AM   #9
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,628
Thanks: 58
Thanked 1,456 Times in 1,437 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Text Box boarder color

Quote:
Originally Posted by Dick7Access View Post
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.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-05-2019, 12:43 PM   #10
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,235
Thanks: 10
Thanked 232 Times in 220 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Text Box boarder color

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

Micron is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
change text box font color when another text box is not empty shatteras Forms 3 04-11-2016 04:54 AM
Text box bg color in continuous form: the color being the value of the text box pma74 Forms 1 07-13-2013 06:14 AM
Eliminate Boarder grnzbra Reports 8 08-31-2006 12:05 AM
report's window boarder missing action Reports 1 12-06-2004 07:12 PM
Change Color of Text Inside Text Box crhodus Forms 1 05-23-2001 07:55 AM




All times are GMT -8. The time now is 01:29 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World