Unfocus datasheet subform (1 Viewer)

[amir0914]

Hi all,
As you know the first row of datasheet is always focused and highlighted as default when we open a form, I'm trying to find a way to deselect the first row . Do you think it's possible ?

 

[arnelgp]

if the Datasheet is the Only control on the form, then it will take focus.
what you need is to make the Datasheet as subform and add an Unbound textbox.
set the the Tab order of the form so that the Unbound textbox received focus first.
Set the height and width of the Unbound textbox to 0.

 

[amir0914]

if the Datasheet is the Only control on the form, then it will take focus.
what you need is to make the Datasheet as subform and add an Unbound textbox.
set the the Tab order of the form so that the Unbound textbox received focus first.
Set the height and width of the Unbound textbox to 0

I did it, but nothing happend. The first record of the sufrom is still focused. (the datasheet is as a subform on main form and I created a textbox on the main form and make focuse on the textbox.)
Could you please attach a sample .accdb if you've done it ?

 

[arnelgp]

sorry, i don't think you can remove the highlight.
you can try to use conditional format, and remove it when
the subform has focus.

 

[Pat Hartman]

What problem is caused by having focus on the first row?

I think the only way you can get around this is to set the "Allow" properties to no.