Highlight Row in Continuous Form 2

[cstuart79]

Is it possible to highlight (ie. change backcolor) of entire row in a continuous form upon clicking cmd button?
I believe it would require conditional formatting, but this does not appear to be allowable for entire row.

 

[dhookom]

cstuart79,
Do you have a value stored in the row/record that identifies if it should be formatted?

What is the reason for the highlight? Is it like just a temporary pointer to a record? Does the row have a primary key field?

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

Make a large textbox the size of the detail section, and send to back. Apply the conditional formatting to the textbox. It will appear as if the row hilites.

 

[dhookom]

When using MajP's suggestion, make sure all the other controls have the background set to transparent. You might also try set these properties of the large text box:
Locked: Yes
Enabled: No
Tab Stop: No

I think you still need a unique value in the form that can identify which row to highlight.

Duane
Hook'D on Access
MS Access MVP

 

[cstuart79]

i want to use the highlight like a temporary pointer to a record on a continuous form.
the idea is:

when user clicks button on continuous form, "separate form" becomes visible with details and row becomes highlighted to indicate which record it refers to. when user clicks "close" button on "separate form", the form will close and row will go back to being unhighlighted.

i'm not sure how to accomplish this using conditional formatting "expression is

 

[dhookom]

I have twice mentioned the need for a unique value in the subform. You have yet to mention if this is available in the continuous form .

I would set a hidden text box's value to this unique value and then use this text box to compare to the value in the continuous form for the expression is.

Duane
Hook'D on Access
MS Access MVP

 

[cstuart79]

So I have like 3 things going on all at once here that relate to one another:

1. On click event of button causes SESSIONS_SOURCES form to become visible. This is functional.

Private Sub Command34_Click()
Me.Parent.SESSIONS_SOURCES.Visible = True
End Sub

2. SESSIONS_SOURCES form should be filtered using where condition based upon unique field "Session_ID". This is not functioning.

Private Sub Command34_Click()
Dim strWhere As String
strWhere = Me.Session_ID
End Sub

3. On click as filtered form becomes visible, entire corresponding row of record on continuous form becomes highlighted. I have added large text box to utilize conditional formatting. However, do I set it to change colors based upon
If Me.SESSIONS_SOURCES.Visible = True
or based upon unique field "Session_ID"
or both?

 

[cstuart79]

thanks duane--you helped me resolve this with the pop-up solution!