Conditional Formatting in Microsoft Access Forms and Reports

摘要

Every Access developer faces the problem sooner or later. You change a property of a control on a continuous subform, and to your dismay, it affects all the rows of the form. For example, suppose you want to make all order quantities greater than 10 stand out. Perhaps, you would write code in the AfterUpdate event of the txtQuantity textbox that looks something like this: like this: With Me. txtQuantity.FontBold=(.Value > 10) End with And what would this magnificent code do? As you edit the quantity, your code would change the boldness of the quantity text on every row. The problem, of course, is that each control on a continuous form has only one set of property values; there isn't a different set for each row. When you change a property, it affects all the rows. The above example uses the FontBold property (which is either true or false), but what you really want to achieve is different colors for the fore color or background color based on some expression, or perhaps simply based on whether the control has focus.