Format record color in query

[Faction21]

Is it possible to fomat the color of a record in a query if it meets certain criteria such as:

number<1000 , then display the record in red

I looked it up in the microsoft access help, but i cant make sense of what they are talking about.



Any help?

-thanks

 

[ColinEssex]

Show the query results in a form and do it there.

Col

 

[JohnGo]

You can do so in a form but not when the record is in tableview.
If your records are shown in tableview forget it. So use the standard form options of flat fields and use the properties of the control box to add some color flavour.

 

[WayneRyan]

Faction,

You can't format your query results. Make a continuous form and use
Conditional Formatting. It will give you the results you want.

Wayne