Bolding a record in a field that is the max

[salisbut]

Pretty sure this is not possible but I thought I would ask. Is there a way to bold one record in a field in a query? Instead of having the maximum show up in the totals row, I would like to bold the maximum value in a column. Is this possible? I there some function out there that bolds text?

[NTC]

Well not in a query. But in a form, which is sourced on that query, you may be able. Conditional Formatting is a standard offering you will see for a form when in design view. Its not a feature I much use - so I don't have advice at my finger tips. But definitely it is where to look. On the otherhand if you think a report is more appropriate than a form - it also may be viable. One can probably toggle font during the OnFormat event.

Sorry am not of more help at the moment.

[salisbut]

Ah shoot ok so if I were to create a subreport in a report that was a query it seems that I could not bold the max in a certain field. Ok this is what I thought. Thanks for the help though.

[pbaldy]

It's certainly possible (in a form or report, not directly in a query). The trick is to identify the max value. A couple of ways come to mind. If you have a single max value, you could put a textbox on the form that finds it:

=Max(FieldName)

Then use that in Conditional Formatting. If you have a max per group or something, I'd probably have a query that found the max for each group, join that to the main query, and create a calculated field that identified the matching record, then use that in Conditional Formatting.