Conditional formatting to, "=sum"

[AZstudent]

I am on the last task on my midterm and I am STUCK. In my report I have, " =Sum([ReEnrollmentFee]) " in my group footer. Well now I have to some how use conditional formatting so that when any of the values (results from the 'sum') are , " equal to 0 " it will appear in red. I just can not remember how to go about this. Help, please.

[ajetrumpet]

in 2007, right click on the textbox that contains this field and choose "conditional formatting". everything should be self explanatory from there.

Are you going to school online? If so, be careful of your web activity while you're logged on to their server or your school account. Online schools all use 3rd party software companies to monitor web activity of your IP address associated with the account so they can prevent plagerism and cheating on exams.

I don't know if they can track your movement outside of the their own server environment because that might be invasion of privacy, but I would guess they can, and are.

I know that system administrators can do it in the private sector.

[AZstudent]

Ok I'm sorry but my novice level is really going to shine through right now. You said to right click the 'text box' ?? Ok so I went to design view for my report, went to the ExpirationDate Footer, then went to the totals field where I have it totaling - " =Sum([ReEnrollmentFee]) " I right clicked but I do not have a option for "conditional formatting". Next question though, lets say I did, is that going to be an "IIf" function?? If so how do I write that one, I mean the part about making the 'zero values, RED' ?

[ajetrumpet]

don't do anything in the footer. report footers and page footers are both summary-type sections. your records should be in the detail section of the report. in design view, there should only be one line of controls in the detail section because reports are usually continuous in nature (multiple records displayed, one after the other).

if the menu option is not there, you might have it turned off. it is located in the access options under the ribbon menu, but I forget what section it's under. I think "current database". look for "use shortcut menus" or "use full menus".

if that doesn't work, you can always click the property sheet icon in the design tab of the ribbon and put some code behind the "on load" event. for what you're doing, you can probably write something like this:

me.textbox.formatconditions.add acfieldvalue, acequal,0
me.textbox.formatconditions(0).backcolor = RGB(255, 0, 0)

be aware though, that you should only use the ADD code above once, NOT on the load event because it will add a condition to your textbox everytime you load the report. if you do use that, run it once only and then delete it.

RGB() is a basic color function. you can only get red, green and blue from it. 255 is the max value for each argument. e.g. - for complete blue color, use (0,0,255).