A have noticed a lot of queries regarding changing the back colour of a
text box in continuous forms within these forums and others. Years ago I
created our database which has just this feature incorporated.. it has no
events or code associated with Table1 or Form1, yet the CID field on Form1
changes colour dependant on if a value is stored within the Invoicee field
of Table1. I am not sure if I will be adding this feature to the new
database but I would like to know how it works for my own future reference
and that of others in this forum.. A very basic example of this in action
can be seen in the attached example.. Try removing or adding any text
within the invoicee field in Table1 to see the effect in Form1 - Any
cleverer bods than I who can discover the method used and advise would be
appreciated.
text box in continuous forms within these forums and others. Years ago I
created our database which has just this feature incorporated.. it has no
events or code associated with Table1 or Form1, yet the CID field on Form1
changes colour dependant on if a value is stored within the Invoicee field
of Table1. I am not sure if I will be adding this feature to the new
database but I would like to know how it works for my own future reference
and that of others in this forum.. A very basic example of this in action
can be seen in the attached example.. Try removing or adding any text
within the invoicee field in Table1 to see the effect in Form1 - Any
cleverer bods than I who can discover the method used and advise would be
appreciated.
