Can someone please help me with if the RGB( red,green,blue) function can be used to set the backcolor of a field in a form in Datasheet view?
I have a list of items in a table and each item can have a distinct colour. in a table I have the Item name field and fields for Red, Green, Blue that contain the individual RGB values. I want to have a form in a datasheet view format that shows a selected number of items and various other details for that item from other tables as a list. Then I also want to show a blank field next to the item names in the list result that displays the colour of each item automatically by setting the backcolor of this field using the relevant Red, Green, Blue values . I have tried using something like =Backcolor RGB([Red],[Green],[Blue]) (I know this is wrong, just giving it as an example) in various OnOpen properties for the blank field but cannot get it to work.
Is it possible to use these functions and properties in this way? If so can someone please point me in the right direction on how to correctly write the function? Should I be doing it differently as part of a Dlookup() or IIF() function instead?