Formatting Font/Color Query Results

[jcbuche]

Hi all,

I'm trying to figure out how to format the results of a query.

Basically if the results of this table are greater than this, make bold, set font color to red, whatever, basically anything that would distinguish it.



I'm thinking it would look something like this...

Format([dbo_slcdpm]![fcustno]>"300516"," "bold")

Thanks for any help.

[pbaldy]

In a query? I doubt there's a way. In a form or report textbox, it's easy with Conditional Formatting.

[jcbuche]

Well technically not the query, but the results of the query?

[pbaldy]

As long as the results of the query are in a form or report.

[jcbuche]

Well the results shown in attachment, after running the first query.

[pbaldy]

Like I said, in a query I don't think it can be done. My users have never seen a query and they've never seen a table. They see forms and reports, period. One reason is that you have no control when they're in a table or query. Present that data in a form or report and your solution will be simple.

[jcbuche]

Whats the best way to present the data in a form or report?

[pbaldy]

The normal method is to make your query the Record Source of either. You could start with the wizard. My rule of thumb is that forms are for letting the user interact with data (add/edit/delete) and reports are for viewing.