Detect form view change to datasheet

[coypu]

Hi, how does one detect immediately a form is changed from normal to datasheet view?

 

[isladogs]

You could add code like this:

Private Sub Form_Current()
    If Me.CurrentView = 2 Then MsgBox "Datasheet view"
End Sub

The full list of values are

Setting	Form displayed in:
0	Design view
1	Form view
2	Datasheet view
7	Layout view

Or you can prevent datasheet view completely in the form property sheet

 

[coypu]

Excellent, thanks Colin
I forgot about testing during the form's On Current event.