Making highest numbers Bold

[rarejoep]

From a query, I get results of tests. There are 2 results per test, and I would like to get the highest of the 2 results bold. Does anyone know how I can do that?

 

[Fizzio]

You could try this but I'm not sure if it will work !

If you sort the test results by value ie highest first, on the On_Format event of the detail section

Detail OnFormat()
if me.formatcount = 1 then
me.NameOfValueTextbox.FontWeight = 6
end if

Try at your peril!

 

[rarejoep]

Is it also possible to include some kind of If-Then query, that selects the highest result and makes that one Bold? Because it's not sorting and both results are shown.