Help with conditional formatting

[Leopardfist]

Below is a description of a report, and what I need to do to it. I know I can use conditional formatting to do it, I just dont know how to code it.

Report:

Each row consists of a member and lists the following info...

Name Address Phone Superclub Member(Y/N) VIP(Y/N)



Now, what I want to do, is to make the report highlight ALL superclub Members yellow... and all VIPs red. Those particular fields in the table are Y/N fields.

Can anyone tell me how to go about doing this?

 

[KenHigg]

Have you made to the conditional formmating dialog box? Seems you can do it there...


ken

 

[Leopardfist]

I'm not sure what you mean. I know absolutely nothing about conditional formatting. Can you walk me through the steps to check what you need me to check?

 

[KenHigg]

There's another thread chasing this rabbit - see if it helps:

http://www.access-programmers.co.uk/forums/showthread.php?t=138636

 

[Leopardfist]

I read thru that post, but it really doesn't help me on my issue. I think the difference is that I need my conditional formatting to apply only to those records which meet the standard.

Also, I want the entire row of data to be highlighted, not just the field for which the conditional formatting is checking. So I need to code the condition rather than use the typical conditional formatting option that only checks for values for the current control.

Is it possible to have code that runs for every record in a report, so that only those records (customers) who meet the condition are highlighted?

So the name has to be highlighted, the customer number, and address for anyone who is a VIP for instance. I know this means I have to do the conditional formatting for each field, I just dont know how to do it.

 

[KenHigg]

You should still be able to do it with conditional formatting. Can you google help on it? Can you post a sample db?

 

[Leopardfist]

Let me make a copy of my DB Ken and delete most records so it isnt so big. I hope it doesnt exceed max file size limits.

Now my example is nothing like what I need hehe. But I can tell you exactly what report I need and what I need done to it, which may even be easier on you.

Gimme a few minutes to fix a copy up and get it attached.

 

[Leopardfist]

OK Ken,

What I did was delete all but about 17 records, ALL forms and reports and queries other than the main form, main table, and the report I am working on... so I got it small enough to zip up and upload to here.

Once you get it can you email me so that we can discuss the intimate details of the program in private? My email is lee0180@bop.gov

Thanks Bro!

 

[KenHigg]

Which report is it?

Edit: My bad, never mind... I'm looking

 

[Leopardfist]

Ken,

Basically what I need is this..... if you look at the report you will see a couple check boxes... one is titled DES. If that check box is checked (You will have to go into the form and check it in there because being the numb skull I am I deleted all the records who had it checked hehe) I want the entire row of fields to have a grey background color, so they appear highlighted, but just for that inmate.

When you open the main form titled (Enter Inmate Data) there are a BUNCH of check boxes in the middle right. The one that you need to check is named Designated.

 

[KenHigg]

See if this is what you had in mind...

 

[Leopardfist]

That is EXACTLY what I need bro , HOW do I do it hehe.

 

[KenHigg]

It's a text box behind the others that uses conditional formatting...

 

[Leopardfist]

The DB you sent me is read only, so I cant open the code. Will the background textbox grow with the others? I think I use the cangrow option on them.

 

[KenHigg]

Hang on and I'll send you watered down version...



Edit: We may have to dream up something else to make the on grow thing work...

 

[Leopardfist]

Hey Ken... if I apply that conditional formatting to each control on the row, it would work the same right?

I tried doing what you did, just adding a text control and placing it behind the other things, but I cant get it to work. The yellow covers up my text from my controls.

 

[KenHigg]

1. Yes that should work (I'm not sure what would happen with a check box?)
2. You will need to Format->Send to back the yellow textbox.

 

[KenHigg]

Did you select the yellow text box control and do Format->Send to back?

 

[Leopardfist]

Hey Ken,

One more question.... now they are wanting it to be a text control rather than a checkbox. So essentially my expression will be if not equal to "" (not blank) then highlight.

How do I write the code for that? Assume the same control names.

Reports![SHU Monitor Roster Designated]![Two-Hour Watch] != " "

Is that right?

 

[KenHigg]

So instead of showing the check box and have it display a checked/unchecked status you don't want to see the check box at all and rather simple have the row highlighted if the value for the check box is true (Checked)?