Changing background color based on data

How can I change the color of a textbox based on if it has data??
Jass SainiAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
CF
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
This is perfect application for Conditional Formatting ...

mx
0
 
Dale FyeCommented:
Is the control bound to data?

You can use conditional formatting.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Dale ... control does not need to be bound.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
OR ...

CF 2
0
 
Jass SainiAuthor Commented:
Hello..that's awesome that it is that easy.  I did that and nothing.  My textbox is bound
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Did you try both approaches I posted ... just to be sure ?
In the one, be sure text box Name is in brackets.
0
 
Jass SainiAuthor Commented:
Thank You....
0
 
hnasrCommented:
Ok! Was that simple!
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You are welcome ...

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.