Row color based on query data?

[dhempy]

Is it possible to have returned values in different colors based on the contents of a separate field? I have a name field and a separate Y/N field. If the value of that field is "N", I would like the returned name to be red, otherwise, leave the name black.

This query is used in a ROW source query for a combo box so I'd like the pull-down to have the colors work.

Thanks in advance.

Dan

 

[lupins46]

No; it's not possible.
If you want different colours you will have to use a continuous subform.