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
|
|||
|
|||
Conditional Formatting
In my data base I am asking to color code field "A" in green if the amount
is less than filed "B". I have also asked for field "A" to highlight blank records in purple. Can you ask for different colors and different criteria of the same field? I tried doing this and it worked for only the purple expression and highlighted in green the oppposite field of my expression? I hope this make sense? -- Merlin |
#2
|
|||
|
|||
Conditional Formatting
Using Conditional Formatting from the Format Menu you can have three
different conditions with associated colors plus a Default Color for a given control. If the form is a Single View Form you can have as many conditions as desired, using code in the appropriate control's AfterUpdate event as well as in the Form_Current event. What exactly is your situation? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201002/1 |
#3
|
|||
|
|||
Conditional Formatting
I am working in reports. I do not know how to ask for the difference between
two columns of numbers. I want to show when one column of numberes is larger that the other by color coding it. When I ask this I get the opposite result. see example: Per occurance amount -- Merlin "Linq Adams via AccessMonster.com" wrote: Using Conditional Formatting from the Format Menu you can have three different conditions with associated colors plus a Default Color for a given control. If the form is a Single View Form you can have as many conditions as desired, using code in the appropriate control's AfterUpdate event as well as in the Form_Current event. What exactly is your situation? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201002/1 . |
#4
|
|||
|
|||
Conditional Formatting
here is my situation:
In my report I am asking to color code a field in the "Per Occurance Amount" column when the dollar amount is less than the "Contract Per Occurance Amount" column. When I ask this in my conditional formatting box it colors a box in the "Per Occurance Amount" column when it is greater than the "Contract Per Occurance Amount" column. In other words I get the opposite result of my question. -- "Linq Adams via AccessMonster.com" wrote: Using Conditional Formatting from the Format Menu you can have three different conditions with associated colors plus a Default Color for a given control. If the form is a Single View Form you can have as many conditions as desired, using code in the appropriate control's AfterUpdate event as well as in the Form_Current event. What exactly is your situation? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201002/1 . |
#5
|
|||
|
|||
Conditional Formatting
"Linq Adams via AccessMonster.com" wrote: Using Conditional Formatting from the Format Menu you can have three different conditions with associated colors plus a Default Color for a given control. If the form is a Single View Form you can have as many conditions as desired, using code in the appropriate control's AfterUpdate event as well as in the Form_Current event. What exactly is your situation? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201002/1 . |
Thread Tools | |
Display Modes | |
|
|