Workaround for Format Conditions limited to 3

[isladogs]

Updated link https://www.utteraccess.com/forum/index.php?showtopic=2034035
Having skim read it, the suggested solution is almost identical to that given here by Royce

 

[Joce1]

shoot! thought he was asking for a solution, didnt even noticed he was actually giving the solution with the "skip 0 to 2" thing
sorry

 

[isladogs]

No problem. Thanks for your contribution

 

[tvanstiphout]

Perhaps worth mentioning: MSFT acknowledged a bug and will fix it:

The problem occurs when you try to add more than 3 conditions, and there are spaces in the expression for any of the first 3 conditions.
If you remove the spaces (e.g. change "[FieldName]= 'value' " to "[FieldName]='value'"), then you won’t hit the problem. There might be other things that could trigger the problem as well besides spaces in the expression. The problem does not occur above the first 3 conditions.