Thursday, August 14, 2008
Colouring a Textbox on a Continuous Form based on a record's value
It appears that the OnCurrent event of a Continuous Form View will action but will colour the relevant Textboxes, the same colour. The obvious way to apply formatting properties based on each record's value is to use the Conditional Format of the Textbox. The Object Model keyword for this is .FormatCondition and there are up to three OR criteria. See frice's weblog for a VBA setup example.