Question Conditional Formatting

[mm07nkb]

Hi,

I have an unbound textbox that I want to apply conditional formatting to.

I have a listbox and when certain rows are highlighted in the listbox I want my unbound textbox to turn grey scale.

My listbox is sourced from a seperate table.

Any help would be greatly appreciated!!

Im on Access 2007

Thanks

 

[CBrighton]

I have limited experience with listboxes, but I would guess you need some code in the change / after update event of the listbox to check if a certain row has been selected.

As an example, the following code would go through and check each row in the listbox and displays messageboxes for each selected row (copied from elsewhere, untested by me):

Dim intI as Integer
With Me.List0
   For intI = 0 To .ListCount - 1
      If .Selected(intI) Then
         msgbox "Row " & intI & " selected."
      End If
   Next intI
End With