If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I format a field based on the value
I have a form that is populated from a query using several tables. In the
detail section I have the following fields: Category Code qty PO number ... .... ... The qty is populated in the query based on whether or not a PO number is available. If the PO number is not available then it comes from table a, if it is available then it comes from table b. On the form, I have my fields color-coded for easy reading. I would like to be able to color the border and column heading based on where this value comes from. If table A, then it is blue, if table b then it is red and blocked from being updated (Locked = Yes). Is this possible to do and if so How? If VBA coding is involved, please spell it out for me as I'm still learning this. Thank you. |
Thread Tools | |
Display Modes | |
|
|