Conditional Formatting?

Access does not support conditional formatting in the same way that Excel does. While Excel allows for complex conditional formatting based on formulas and comparisons between cells, Access has more limited capabilities in this regard. In Access, you can use validation rules to enforce certain conditions on data entry, but these do not provide the same visual formatting capabilities as Excel's conditional formatting.

For your specific scenario of comparing two text boxes and changing the color of one based on the value of another, this functionality is not natively supported in Access. You would need to implement a workaround, such as using VBA (Visual Basic for Applications) to change the properties of the controls based on their values. However, this requires programming knowledge and may not be as straightforward as using Excel's built-in features.

In summary, while you can perform comparisons and validations in Access, the visual conditional formatting based on those comparisons, like in Excel, is not directly available.

You should be able to use the Eval() function to create an expression that can be used in conditional formatting. This is a form with two fields [Condition] and [NumberValue]. The left text box has a control source of =Eval([NumberValue] & [Condition]). I used the same condition/expression in without the "=".