conditional formating with VBA onLoad

[theDBguy]

Note that whilst you can have up to 50 format conditions using the CF wizard, you can only have 3 format conditions per object using VBA. There is an obscure workaround to that limit but in general there is no advantage using VBA for this purpose.

@isladogs I thought we already sorted that out earlier. I'll do some digging through prior threads.

Edit: Found this old thread.

Workaround for Format Conditions limited to 3

As many of you know, you can set lots (Some say 32, some say 50) of Format Conditions in Design View by right clicking a text box and Selecting Conditional Formatting. But you try it in code and you will get errors if you try to set more than 3. (Internally, there is a Microsoft BUG, not a...

www.access-programmers.co.uk

 

[isladogs]

@isladogs I thought we already sorted that out earlier. I'll do some digging through prior threads.

Edit: Found this old thread.

Workaround for Format Conditions limited to 3

As many of you know, you can set lots (Some say 32, some say 50) of Format Conditions in Design View by right clicking a text box and Selecting Conditional Formatting. But you try it in code and you will get errors if you try to set more than 3. (Internally, there is a Microsoft BUG, not a...

www.access-programmers.co.uk

Hi
Thanks. I was indeed referring to that thread. I've successfully used @Royce's method in the first post.
But unclear 'what had been sorted out earlier'?

 

[theDBguy]

Hi
Thanks. I was indeed referring to that thread. I've successfully used @Royce's method in the first post.
But unclear 'what had been sorted out earlier'?

That you can have more than three (3) FormatConditions when using VBA.

 

[isladogs]

That you can have more than three (3) FormatConditions when using VBA.

Yes, but as I said originally, only if you are aware of the workaround which AFAIAA isn't mentioned in any official MS documentation

 

[theDBguy]

Yes, but as I said originally, only if you are aware of the workaround which AFAIAA isn't mentioned in any official MS documentation

Funny thing is; although that thread I linked to started out as saying it's a "workaround," it's not the same demo I seem to remember. I thought I posted one (somewhere) where multiple colors were showing? Still, though, if you open the form in design view in that demo and check for any Format Conditions set at Design View, you won't find any. And yet, when you run it, more than three FCs are applied. So, either it's not really a workaround, or MS may have fixed the problem already (I just didn't hear about it).

 

[isladogs]

Who knows? Anyway, there are other approaches with millions of possible colour formats (256*256*256)

See http://www.mendipdatasystems.co.uk/colour-conditions/4594464193