Highlighting Records

[Gord]

Using VB, when records are brought up in datasheet view (either a query or
table), is it possible to highlight (or in some way visually flag) certain
records? If so, how is this 'highlighting' accomplished? Note that the
records would most likely not be contiguous. The purpose being to bring
those records to the users attention when required.

Thanks,

Gord

Note that I am using Access 2007

[Allen Browne]

You can use Continuous Formatting to format fields that meet certain
conditions.

Alternatively, if you are trying to highlight the fields that are required
or the control that has the focus, see:
http://allenbrowne.com/highlight.html

Or, if you want to highlight the text in a field that matched search
criteria, see:
http://allenbrowne.com/AppSearchHighlight.html
(The last one applies to A2007 only.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Gord" <x1******@telus.netwrote in message
news:JpwPk.5932$%%2.269@edtnps82...

Using VB, when records are brought up in datasheet view (either a query or
table), is it possible to highlight (or in some way visually flag) certain
records? If so, how is this 'highlighting' accomplished? Note that the
records would most likely not be contiguous. The purpose being to bring
those records to the users attention when required.

Thanks,

Gord

Note that I am using Access 2007