Highlight row in Continuous Form

Question

I have a continuous form that is quite wide.  When the user is trying to read across, its somewhat hard to follow across.  So, I would like to have the user select the record using the record selector and change the background color of the records in that row or highlight it in some way.  Is this possible?

Answer 1

Hey Marshall,

I'm trying to follow what you are saying to do here but I'm having trouble. How are you coding this? Thanks in advance.

Answer 2

There is only the one line of VBA in the form's Current event procedure (not the OnCurrent event property).  I thought I clearly(?) described all the details in my post, so can you provide more information about what part is causing you trouble.

Answer 3

Someone else explained your method to me so I get what you were saying now. You explained it clearly, I'm just new to Access and couldn't find the OnCurrent property. Thanks for the help.

Answer 4

I tried this but couldn't get it to work.  When you say CF, what do you mean.  Also, I did everything including selecting the text box and created an expression Forms!frmMaster_PriceBrand.txtCurrent.Backcolor = vborange.  Then I tried vbyellow, and then #EEB500, and then just plain yellow, orange.  No luck.  What did I do wrong.

Answer 5

I tried this but couldn't get it to work.  When you say CF, what do you mean.  Also, I did everything including selecting the text box and created an expression Forms!frmMaster_PriceBrand.txtCurrent.Backcolor = vborange.  Then I tried vbyellow, and then #EEB500, and then just plain yellow, orange.  No luck.  What did I do wrong.