Continuous Form Conditional Formatting

[MattBaldry]

Hi All,

Is it possible to use conditional formatting on a continuous form, but get the colour from a table? Lets say I have a status table like below.

StatusID	StatusName	StatusColourRGB
1	Enquiry	51, 255, 255
2	Open	246, 255, 51
3	Ordered	51, 255, 51
4	Closed	255, 162, 51

Is it possible to conditional format the form using the StatusColourRGB field? This would mean I could add more status options and colours without having to format the form.

~Matt

 

[KitaYama]

You can add conditional formatting in vba.
You can read your color from a table and add them accordingly.

and as far as I remember there was a limit.

Use conditional formatting in code for easy maintenance and less work

Illustrates how to apply conditional formatting using the controls collection for easy application and maintenance. It also overcomes the three limit rule.

accessexperts.com

or google it

 

[MajP]

See solution
Post in thread 'Programatically change color on continous form conditional formatting' https://www.access-programmers.co.u...rm-conditional-formatting.323250/post-1827429

 

[arnelgp]

you can also call a user-defined-function that will change the background
of your status color (on paint event, or various events).

 

[isladogs]

You can have up to 50 conditional formats using VBA.
However, if you are storing the colour codes in a table, you can have an unlimited number of colours and don't need conditional formatting.
For example

For a full explanation and example app, see my article

Colour Conditions

Originally only 3 colour conditions were allowed using conditional formatting. This limit was later increased to 50 conditions using the wizard or code.This shows another method of obtaining an unlimited number of colour formats in VBA without using conditional formatting.

www.isladogs.co.uk