Macro If statement syntax error

[euphonium01]

I am trying to create a Macro attached to the 'On Current' property of a Form. I need the Macro to change the BackColor of a control (called [Status]), base on the percentage of another control (called [Sales Potential]), the percentages are 0 to 10, 11 to 20 etc up to 100 % using a different color for each. I tried the following:



If [Sales Potential] >=0 And <=10
SetProperty
Control [Sales Potential]
Property BackColor
Value #000000

[Sales Potential] >=11 And <=20 and so on.

The above returns "syntax error, Cannot Parse the Expression >=0 And <=10", when I try to save.

I also tried [Sales Potential] Between 0 And 10. SetProperty etc This saved but didn't work when I tried it.

I've tried Else If statements, Else Statements for other percentage increments, but cannot get anything to work.

I know the answer will be easy to someone, can anyone help a novice resolve this, I would be most appreciative.

[pbaldy]

Have you looked at Conditional Formatting on the ribbon? It's the simplest way to do this type of thing.

[mrojas]

Try the following:

If [Sales Potential] >=0 And [Sales Potential]<=10

[euphonium01]

Have you looked at Conditional Formatting on the ribbon? It's the simplest way to do this type of thing.

Yes, I tried that, it worked for anything from 0 To 10, and from 11 To 20, after that (21 To 50 or 51 To 75 etc) wouldn't work?

[JoeM]

Note: If the numbers are really percents, you will need to use percent signs or decimals in your equations, i.e. 10% or .10.
Percentages are equivalent to fractions/decimals between 0 and 1.

[euphonium01]

Many thanks to both mrojas and JoeM. Not sure which was right (as it's now working I don't wish to change anything to check it out). I used mrojas' suggestion of using the control name for both set of criteria, and also used JoeM's correction to change the numbers to a decimal (0 became 0.0 and 10 became 0.1 etc).

Thanks to all who sent their help