Highlight Row of Continuous Form

  • Thread starter Thread starter Kirk P.
  • Start date Start date
K

Kirk P.

I read previous posts on this subject, and for some reason can't get it to
work. I'm using Access 2007, so either I've done something wrong (most
likely), or it's a version issue.

I've got a continuous form (frmProdID_Research) that displays the records in
tblProdID_Research. I've placed an unbound text box called txtRec_ID in the
header section of this form, and placed this code in the On Current event:

Me.txtRec_ID = Me.txtProd_ID

For the "conditional formatting" part, I've got an unbound text box called
txtHighlightBox. I've set the CF expression is box to
[txtRec_ID]=[txtProd_ID] and set the Back Color to Yellow. I've set the
postion of txtHighlightBox To Back, and set the Back Style of the other
controls to Transparent.

I don't get the Yellow row color when I select a record, but I can see that
the Product_ID of the selected row is correctly represented in the txtRec_ID
control. Does anyone spot a problem with what I've done thus far?
 
NEVER MIND. Amazing what stepping away for a while and clearing your head
will do. Visible property of txtHighlightBox was set to NO.
 
Back
Top