Turn Off Datasheet Subform First Row Highlight

[PSSMargaret]

Is here any way to turn off the first row highlight in datasheet subforms? It's very distracting.

[RuralGuy]

It sounds like you do not intend to let the user edit on the subform. Have you tried just disabling the subform?

[Micron]

could try this on the subform

If Me.SelHeight > 0 Then
Me.SelHeight = 0
End If

You get that because the first record is selected - combo box seems to have the focus too.

[PSSMargaret]

The user will be updating information in that form. Changing "Enabled" on the subform didn't remove the highlighting.

[RuralGuy]

How will you indicate which row of the sub form the cursor is on?

[PSSMargaret]

Each fields has conditional formatting that turns a color when it has the focus.

[RuralGuy]

Got it. I'll play a bit and get back to you.

[Micron]

Then methinks your only option is to convert the form to a continuous view. If you need the datasheet look, you can replicate that in a continuous form. If you don't want the control with the focus in the first record to look selected or highlighted, then in the GotFocus events for such controls, you can set their SelLength to zero.

[PSSMargaret]

Using a continuous form won't work. The client needs to be able to sort and filter the data in the form. Some records have a large number of rows in that subform.

[Micron]

I don't see the problem with being able to do sorting and filtering on a continuous form. Since you seem to be so sure of what won't work without considering much of anything suggested to you, I will bow out.

[PSSMargaret]

All I meant was that the client likes the format of the datasheet. It sorts and filters like Excel which they are familiar with and they can also move the columns around.

[RuralGuy]

Maybe there is something in here: https://vb123.com/you-can-do-that-with-datasheets/ that you can use.