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?
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?