Not quite sure what you are asking. Are you suggesting that a user should not be able to select one of the rows in the datasheet form? It would also help to know if you are talking about a O365 Web Datasheet View or a "native" datasheet view since they have different properties.
Then you couldn't move on row selection, you have just focus only one fieldThe other fields must have properties
Enabled = False Locked
I think what you are saying is you want users to be able to select a row by clicking on any field but the focus not to to stay on that field.
if that is the case, in each fields got focus event you need code to set the focus to a unbound control. In a form this is not a problem but in data sheets, pretty sure you can’t do this - I’m on my phone to test so create an unbound control and try it. Otherwise try setting the focus to your checkbox.
edit - see this link for an example of moving focus
use a textbox as a resizeable and colourful checkbox
For whatever reason, checkbox controls cannot be resized. This suggestion addresses that issue and also enables the use of colour. To create, put the following in the format property of a textbox and set the control source to a boolean value 1. set format property -...www.access-programmers.co.uk
Well I believe I have answered the question and provided a link to an example
not clear what you want - the example you provided seems to do what you require.kindly suggest.
is this what you meant.
see the code of form's current event.
on design view of form, see the Click and OnGotFocus event of each textbox.
add code to Refresh the form:
Code:Public Function fnMoveFocusToCheckField() If Me.ItemID.Locked Then Me.Check.SetFocus End If Me.Refresh End Function
add code to Refresh the form:
[/CODE]Code:[CODE]Public Function fnMoveFocusToCheckField() If Me.ItemID.Locked Then Me.Check.SetFocus End If Me.Refresh End Function
Public Function fnMoveFocusToCheckField()
If Me.ItemsPK.Locked Then
Me.Check.SetFocus
End If
Me.Refresh
Screen.MousePointer = 1
End Function