| ||||||||||||
|
How To Open Email Using SendObject Access Example Download Send Email Access Sample Download (Advanced) Programming MS Access Security Alternative Inventory Calculations Down Load ( Single User) How To Perform Inventory Calculations (Multi-User) Make Dependent Combo Box Code Access Database Download How To Fill Fields From Combo Box Use Global Variables as Parameters Download Continuous Form Dependent Combo Box How To Program Continuous-Continuous Master/Detail Forms Download Example for Bar Chart/ Bar Graph on Access Forms Programming Crosstab Query Example TransferText & OutputTo Examples DoCmd.OpenForm & OpenArgs VBA Example |
Access Conditional FormattingChanging Visual Properties of Form & Report Fields
Conditional formatting of fields in Access forms and reports provides a powerful
method for highlighting information in an otherwise monotonous continuous form
or report. The ability to trigger visual changes to a field based on a different
field in the form or report is not immediately obvious when using the
conditional formatting wizard.
You need to select Expression when choosing the type of condition from the drop down list in the conditional format wizard. In our downloadable Access database example we set two format on two different fields: The 1st condition is set on the Barcode form field. Here we set the barcode field to change to a red color when the Inv_Qty (inventory quantity) field falls below a threshold of 100. The 2nd condition is on the Price field in the form. Here we set the color of the price field to green when the price is above $10. One word of caution about the conditional formats - if you change field names in the tables at some future date you may have difficulty finding the incorrect reference to the changed field name since the conditional formatting function does not create visual basic code for you to debug or review. You'll need to recreate the conditional format once you find it. In a large complicated form finding the offending reference could take a while. Below is a snapshot of the form:
Here is the link to download the
conditional formatting Microsoft
Access example database. |
|
|
Access Database Examples • Microsoft Access Templates • MS Access Tutorials |