HIGHLIGHT only the top Value on the screen

[editolis]

Hi All,
I need your help with a form.
I want to highlight always the TOP number from the screen.
I Want RED BACK COLOUR AND WHITE NUMBERS.
Only one field at the screen, the BIGGEST Number.
Can somebody help?
I have also a very sample DB to help me solving this problem.

 

[editolis]

Uncle Gizmo thank you for your help but this is not what i am looking for.

For example from your db you attach at the record 1 the red colour have to be at the number 44.

At the second record the colour have to be at the number 14
and finally from the record 3 the red colour have to be at the number 21.

 

[editolis]

Uncle Gizmo you are very close to the solution.

I have done some small changes for you to see some "bugs".

See the db.

 

[editolis]

OK!

Thank you for your help.

I will try my self and then if i have problems i will come back
tomorrow to help me more if you can.

 

[editolis]

Thank you for your help Uncle Gizmo. Here is the db with all the small changes I have done.
This is almost what I was looking for.
But I want to go further and ask 3 extra questions about this issue.
1.[FONT=&quot] [/FONT]If for example we have on the form let’s say 10 Controls and we want only the 5 to be part of the red color how we can do it?
2.[FONT=&quot] [/FONT]If the numbers are equal can we color them also? For example on the form sometimes we have same numbers but the Function chooses one. Can we fix this?
3.[FONT=&quot] [/FONT] If let’s say on the form all the numbers are 0 or null I do not want the red color. Can we fix this?