Shade One Record (row) in a Table

[vangae]

Wondering if there is a way to shade just one record (row) in an access table. When I try, it shades every other row.

Thank you.

[WendellB]

In general, on a table there is no way to shade a single row. If you want to try doing some conditional formatting on a form or a row, you can set a parameter that will shade a given row, but it doesn't guarantee that there will be just one. On the other hand, if you click the record selector in a table then that row is highlighted.

[MarkLiquorman]

Wondering if there is a way to shade just one record (row) in an access table. When I try, it shades every other row.

Thank you.

As Wendell said, you can't highlight a row in a table, but it can be done on a form. Check-out my website (see below, Tips & Downloads) for an example.

[patt]

Wondering if there is a way to shade just one record (row) in an access table. When I try, it shades every other row.

Thank you.

Here is a database (a la HansV) that allows you to colour records in a form, it has quite a few variations.