Conditional Formatting in a ListBox (Access :: VBA)
Posted on 2007-10-11
I am building a search form that will search for inactive/active records. What I am trying to do is have the inactive records appear in grey and the active records to appear blue. For each record, there is an attribute called blnActive that returns true/false values.
I am capable of determining the SQL, however, I need assistence with the VBA syntax. Here is my pseudo code:
For i = 1 To rec Step 1
item = rsP.Fields(0) & ";" & rsP.Fields(1)
If rsP.Fields(2) = False Then
' this line item should be 8421504
' this line item should be 0
Thank you for your quick response!