That's a different question entirely, and depends on exactly what you mean by
"highlight the
whole record."

You can change the backcolor of each textbox in the record using Conditional
Formatting by

Holding down the <Shift> Key and selecting all of the textboxes
Going to Format - Conditional Formatting and entering

Expression Is [YourFieldName] = "Adams"

or

Expression Is [YourFieldName] > 100

or whatever, then choose your backcolor. The square brackets have to be
around the field name.

Another method, that's quite a bit more complicated,  involves using an
unbound textbox below your other textboxes.

Make it slightly taller than your other textboxes, and long enough to appear
a little to the left of and a little to the right of your row of textboxes.

With the unbound textbox selected, goto Format and select "Send to Back"

Set the Conditional Format for this unbound textbox as described above.

Now, position the textbox so that it's behind the row of other textboxes,
slightly above and below, and slightly to the left and to the right of the
row.  

Now, when the conditional for the given control is met, the unbound textbox,
which should now "envelop" your row of textboxes, will change color, "hi-
lighting" the record.  

The only problem with this method is that if the unbound control gets focus,
it will come to the front, covering your row of textboxes. To prevent this

For the unbound textbox, go to Properties - Other and set Tab Stop to No

Then place this bit of code

Private Sub YourUnboundTextbox_Click()
Me.Field1.SetFocus
End Sub

where Field1 is any control on your record you'd like the focus on. By doing
this, if the user should acidentally click on the "background" textbox, focus
will go to the Field1 and the textboxes won't be covered up.

Good luck!