Conditional Format beyond 3 criteria

[weilerdo]

Hi All, I search the forum but could not locate exactly what I was looking for. I have a Form that is a has 31 fields that I need to color code beyond the 3 that are there. I have seen code that people have tried but everytime I try 1 of them It colors all the fields. I need to it to color 5 criteria. I have attached a screen shot that I hope explains it better. Thanks in advance for looking at this.

"A" = Red
"V" = Green
"T" = Pink
"H" = Lt Blue
"SP" = Orange

 

[jzwp22]

You might want to check out this thread http://www.access-programmers.co.uk/forums/showthread.php?t=148616

 

[missinglinq]

You might want to check out this thread http://www.access-programmers.co.uk/forums/showthread.php?t=148616

As I stated in that thread, your code will only work in Single Form View, and the OP's graphic shows what is obviously either Datasheet or Continuous View.

I've seen dozens of threads with people proposing ways to accomplish the 5 or more colors for these kinds of forms and, in the end, have never seen any that worked.

 

[ChrisO]

Gday weilerdo.

It can be done so if you care to upload a sample of your form and any queries/tables it’s based on, I’ll show you how to incorporate it for one day and you can do the same for the others. You should be good for up to 20 levels.

Regards,
Chris.

 

[Mike375]

Can it be done by overlaying texboxes with the same data and making their background transparent and forecolour the same as the dteail background and then applying conditional formatting to each textbox.

When I had A95 I use to do forecolour by have different calculated felds in the query based on IIF and all but one would give null value. In that case of course I set the font colour in the form itself and background of the top textboxes as transparent

 

[DCrake]

Simple Software Solutions

Hi

In my samples mdb there is a form that utilises an example of mutli coloured formats for contiuous forms. Take a look and see if it will work for you.

Last time I loked at it when the form opened it only showed the first record. Resize the for manually to see the correct layout.

My sample demo's mdb (zipped up) is to big to upload.

CodeMaster:

 

[Cosmos75]

'Conditional Formatting' of controls in a continuous form

Hope that helps!

 

[pl456]

I needed to conditional format once and found a way that worked, not perhaps quite what you want. It involved putting many controls onto the form over the top of one another and setting the following properties to display the control if the condition was met. Obviusly each control would have different criteria. In my case if Field 16 ended in A the word complete would be displayed.

Control source =[Field16] Like "*(A)"
Format ;"Complete"
Fore Color What ever you want

 

[Rajay]

Automatic updation

HI


This is my first posting. I have experience in Excel and Word. I would like to learn access thru internet, forum, help menu and books. I like to create tables, forms to record my production activity in access. Kindly advice on the following issues:

a) DailyProdn: Forms: after entering BrID, BrName should update automatically,

b) Similarly, after posting supID number, SupName should automatically appear, not to allow other names

c) Likewise PrID and PrDesc

Regards

Rajay