MS Access Continuous Forms Highlight Record with Focus ONLY

Attached is the "old school" way of doing it.

New way is to use conditional formatting on a control (same technique as the sample DB, use a control and set it behind all the other controls, apply conditional formatting as needed, then make all your controls backgrounds transparent).

Holler if you need more.

Jim.
ContinuousFormColors.zip

Jim,

I prefer to do this using conditional formatting but am not exactly sure how to set it up.

So, I put a text box in the background the full length of all fields, so that it covers the whole row, and I call it txtBGColor.
I assume that I would need to apply the Conditonal Formatting to txtBGColor but what expression would I use? Would I use an expression that evaluates the value of another field? I don't think that will work.

Sure.
What version of Access?

In Access 2003+ I get that going as follows:
In the detail section I add a control, a checkbox call chkCurrent
That checkbox has a ControlSource of a function called IAmCurrent()

IAmCurrent() is a private function as follows

Private Function IAmCurrent()
IAmCurrent = (Me.JobID = Nz(TheJobID, 0))
End Function

Select allOpen in new window

JobID is the primary key of the recordset on the form
TheJobID is a Public variable in a code module
Public TheJobID As Long

The Current event of the form is as follows

Private Sub Form_Current()
TheJobID = Me.JobID
Me.chkCurrent.Requery
End Sub

Select allOpen in new window

The next effect is that the Current Event makes chCurrent true for just the current record.

And all the controls on the detail section have conditional formatting as follows
Expression IS   [chkcurrent]=True  Background color Yellow

And so, clicking into a different record makes all its controls background yellow, and everything else stays the default white.

Crystal,

I think you just answered the question. Let me implement and test and I will respond shortly.

Thanks!

Crystal,

What is this: " add field to RecordSource:
HighlightBox: Space(50) 'or however many characters are right for your form"

Other than that, I have set it up and it is not working. I think that the color is not showing through because the fields are gray. How do I "turn off" alternate row formatting?

Beautiful. It is working now.

I still do not understand what this is for:
add field to RecordSource:
HighlightBox: Space(50) 'or however many characters are right for your form"

I did NOT add a field to my record source and it is working great.

You do it like this
Current.mdb

Any idea why the textbox I am updating goes gray when it gets the focus? All textboxes are set to background=transparent. But, when I click in it to update it, it is no longer transparent and shows a light gray background.

thanks, Nick ~ I use Back Color and Transparent almost all the time ... so I phrased it the way I use it ;) ~ Interesting to read the definition though.

Genesis, the padding comment should have been right after > "HighlightBox: Space(50)".  I tried to edit my post but Nick already posted too so I couldn't ~

It clearly works as described, but the Help has always been silent about the .GotFocus element of it.
https://msdn.microsoft.com/EN-US/library/office/ff196119.aspx

Syntax
--------------------------------------------------------------------------------
expression .BackColor
expression A variable that represents a TextBox object.

Remarks
--------------------------------------------------------------------------------
The BackColor property contains a numeric expression that corresponds to the color used to fill a control's or section's interior.

You can set the default for this property by using a control's default control style or the DefaultControl property in Visual Basic.

To use the BackColor property, the BackStyle property, if available, must be set to Normal.

glad you've got it working

> "How do I "turn off" alternate row formatting? "

That is the Alternate Back color property of the section (click on the section divider to easily select the section) and you will find it on the Format tab pf the Property Sheet

Crystal - Thank you for an awesome solution to my problem. Thank you for answering the back color issue as well, though it was a little confusing. So, I gave Nick some points for helping to clarify.

You both were a big help and you saved me so much time. I sincerely thank you!

you're welcome ~ happy to help ... and to collaborate on the best solution.  In my opinion, rarely should all the points go to just one ~ life is about teamwork too.