Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Forms Coding > conditional for...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 41529 of 43412
Post > Topic >>

conditional formatting not working

by =?Utf-8?B?emttb29u?= <zkmoon@[EMAIL PROTECTED] > Aug 6, 2008 at 06:22 PM

I have a subform that displays a datasheet. I want to change the background

color depending on a value in one of the fields. I CAN make this work by 
using Conditional Formatting from the ribbon. My problem is that I want to

tweak colors, etc and would like to do this through vba. I have put this
code 
in Form_Open for the subform (declarations left out for simplicity):

Set objFrc = 
Me.subfrmData.Controls("Subj").FormatConditions.Add(acFieldValue, acEqual,

"Math")
    With objFrc
        .FontBold = True
        .BackColor = RGB(255, 0, 10)
    End With

Compiles without error, I can step through and see the values being
changed 
properly....but no change in the display.

Suggestions? I'm pretty sure it's something easy...am ready to be 
embarrassed for myself if I can just get this last little tweak
working..... 
LOL

Thanks in advance.

zkmoon
 




 1 Posts in Topic:
conditional formatting not working
=?Utf-8?B?emttb29u?= <  2008-08-06 18:22:11 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 19:44:42 CST 2008.