On a form I have a pair of calculated fields which are calculated by different means, but should show the same value. Both fields have their Enabled and Locked properties set to "No", and consequently have their backgrounds set to grey and cannot receive focus. I am using conditional formatting with the expression :
Round([CostInclMarkup])<>[TotAllocdCosts]
to set the text colour of the TotAllocdCosts field to red, and that works fine.
BUT, if the conditional fires, and changes the text to red, it also clears the background and the field can receive focus and I am then able to access the TotAllocdCosts field and change its contents.
Does anyone have any idea as to why this is happening, and what to do to prevent it ?
Round([CostInclMarkup])<>[TotAllocdCosts]
to set the text colour of the TotAllocdCosts field to red, and that works fine.
BUT, if the conditional fires, and changes the text to red, it also clears the background and the field can receive focus and I am then able to access the TotAllocdCosts field and change its contents.
Does anyone have any idea as to why this is happening, and what to do to prevent it ?
