How can breakpoints stop responding?

[Guest]

I checked the "Error Trapping" option in the VB Editor's Options dialog. It
is set to "Break on All Errors" Is there something I'm missing? I
closed/reopened the database, restarted Access, even rebooted the
machine...no luck.

To illustrate what happens, I built a simple form with no data source and
there are no controls on the form. The only code I have is this...

Private Sub Detail_Click()
MsgBox Now()
End Sub

I inserted a breakpoint at the MsgBox command. I open the form, click away,
I get my popup with the current time, and no sight of the breakpoint. As far
as I can tell, it doesn't error out either. I even changed it to MsBox and
it does nothing. No error, no warning, no nothing.

What gives?

 

[Guest]

P.S, it is Access 2003 on a Win XP SP2 machine.

 

[Dirk Goldgar]

I checked the "Error Trapping" option in the VB Editor's Options
dialog. It is set to "Break on All Errors" Is there something I'm
missing? I closed/reopened the database, restarted Access, even
rebooted the machine...no luck.

To illustrate what happens, I built a simple form with no data source
and there are no controls on the form. The only code I have is
this...

Private Sub Detail_Click()
MsgBox Now()
End Sub

I inserted a breakpoint at the MsgBox command. I open the form,
click away, I get my popup with the current time, and no sight of the
breakpoint. As far as I can tell, it doesn't error out either. I
even changed it to MsBox and it does nothing. No error, no warning,
no nothing.

What gives?

This will happen if you have unchecked the "Use Access Special Keys"
option on the Tools -> Startup... dialog. If you want breakpoints to
work, you must check that box.

 

[Guest]

RIGHT ON! Thx, you just saved me about a week's worth of work.