We help IT Professionals succeed at work.

Changing background color based on data

Jass Saini
Jass Saini asked
on
How can I change the color of a textbox based on if it has data??
Comment
Watch Question

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
This is perfect application for Conditional Formatting ...

mx
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
Is the control bound to data?

You can use conditional formatting.
Database Architect / Application Developer
Top Expert 2007
Commented:
CF
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Dale ... control does not need to be bound.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
OR ...

CF 2

Author

Commented:
Hello..that's awesome that it is that easy.  I did that and nothing.  My textbox is bound
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Did you try both approaches I posted ... just to be sure ?
In the one, be sure text box Name is in brackets.

Author

Commented:
Thank You....
Hamed NasrRetired IT Professional

Commented:
Ok! Was that simple!
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
You are welcome ...

mx