Hello
I’m trying to set the Backcolor of a control using a Conditional Formatting Expression. In the expression, the idea is to set the Backcolor based on a colour value in another table
I’ve got the following code in the expression…
[cboFilter].[BackColor]=DLookUp("[Colour_Code]","[tblName]","[ID]=" & [txtID])
This just isn’t working. I’ve tried lots of things just to try to get the colour to change e.g. ….
[cboFilter].[BackColor]=vbRed
[cboFilter].[BackColor]=”RED”
[cboFilter].[BackColor]=RGB(255, 224, 244)
But nothing seems to work. (I'm reaching the pulling my hair out stage) Any help very much appreciated.
If this backcolor cannot be changes this way, can it be done using VBA?
Thanks in Advance
I’m trying to set the Backcolor of a control using a Conditional Formatting Expression. In the expression, the idea is to set the Backcolor based on a colour value in another table
I’ve got the following code in the expression…
[cboFilter].[BackColor]=DLookUp("[Colour_Code]","[tblName]","[ID]=" & [txtID])
This just isn’t working. I’ve tried lots of things just to try to get the colour to change e.g. ….
[cboFilter].[BackColor]=vbRed
[cboFilter].[BackColor]=”RED”
[cboFilter].[BackColor]=RGB(255, 224, 244)
But nothing seems to work. (I'm reaching the pulling my hair out stage) Any help very much appreciated.
If this backcolor cannot be changes this way, can it be done using VBA?
Thanks in Advance