I have a form that opens in 'Continuous Forms' view. I know how to have different text fields appear in different colours, based on the value of one of the text fields. Where I'm getting stuck is on trying to set the colour of all text fields for a given record to the value STORED in one of the fields.
I have a field called ItemColourCode in a table. The values in this field are calculated as part of a lengthy overnight process that takes into account days to target, number of people affected, etc. This process updates many thousands of records and takes far too long to run 'on the fly', so I schedule it to run at 2:00 AM. The end result is that each record has an ItemColourCode value of, say, #F00000, stored as a text string.
What I want to do is, as the form opens, set the background colour for each text field to be the value in this field, but I'm not having much luck. I thought getting the formula right to calculate the colour for each record was going to the hardest part, but displaying it has turned out to be more frustrating.
I've tried going to the properties tab and setting the Back Color property for a field to =[ItemColourCode] but that doesn't work. Do I need to loop through all records as the form opens and colour each field? I suspect this might be time consuming.
I'm really hoping that there's a simple way of doing this, of which I'm just unaware.
As always, any suggestions much appreciated
I have a field called ItemColourCode in a table. The values in this field are calculated as part of a lengthy overnight process that takes into account days to target, number of people affected, etc. This process updates many thousands of records and takes far too long to run 'on the fly', so I schedule it to run at 2:00 AM. The end result is that each record has an ItemColourCode value of, say, #F00000, stored as a text string.
What I want to do is, as the form opens, set the background colour for each text field to be the value in this field, but I'm not having much luck. I thought getting the formula right to calculate the colour for each record was going to the hardest part, but displaying it has turned out to be more frustrating.
I've tried going to the properties tab and setting the Back Color property for a field to =[ItemColourCode] but that doesn't work. Do I need to loop through all records as the form opens and colour each field? I suspect this might be time consuming.
I'm really hoping that there's a simple way of doing this, of which I'm just unaware.
As always, any suggestions much appreciated