Formatting one field based on the value in another field.

[Guest]

I am trying to to format the backcolor of a text box based on the value in
another text box. For instance the value in text box 50 is "1", so the
backcolor of Text1 should be vbBlue. I am trying to write this into the Code
window but so far I have been unsuccessful in getting it to work. Any
suggestions?

 

[Rick B]

If it were me, I'd use the built-in conditional formatting features of
Access. Format/Conditional Formatting...

Change the first drop-down to "Expression Is" and then enter the expression
you wnat to use.

Rick B

 

[Guest]

That would work if I was trying to change the format of the field based on
the value in that field, but I am trying to change the back color based on
the value in a DIFFERENT field.

 

[Rick B]

CHANGE THE DROP DOWN TO "EXPRESSION IS" then you can enter any expression
you want....

=[SomeFiledName] <1


=[SomeField] <> [SomeOtherField]

etc.

 

[Rick B]

don't use the equal sign though.


Rick B

CHANGE THE DROP DOWN TO "EXPRESSION IS" then you can enter any expression
you want....

=[SomeFiledName] <1


=[SomeField] <> [SomeOtherField]

etc.

That would work if I was trying to change the format of the field based on
the value in that field, but I am trying to change the back color based on
the value in a DIFFERENT field.

 

[Guest]

THANK YOU! THANK YOU! THANK YOU!~~~~

CHANGE THE DROP DOWN TO "EXPRESSION IS" then you can enter any expression
you want....

=[SomeFiledName] <1


=[SomeField] <> [SomeOtherField]

etc.

That would work if I was trying to change the format of the field based on
the value in that field, but I am trying to change the back color based on
the value in a DIFFERENT field.

 

[Scuda]

Hi All, trying to do something like this and I am getting stuck.

I have a combo box and a text box right next to it for comments. When "UC"
is selected within the combo box, I would like the text box NEXT to it to
turn red. I have tried pretty much all I can think of and I am stuck!!

Thanks so much.

Steph

 

[Roger Carlson]

Use Conditional Formatting.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ConditionalFormatting.mdb" which illustrates how to do this.
You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=375

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L