MS Access VBA stops at hidden/cleared breakpoint

I placed a breakpoint on a line in VBA for my Access database (in the On Load for the form that loads on startup).  I subsequently cleared the breakpoint.  However, Access still halts on the VBA as if the breakpoint was still there.  Any suggestions?

Thanks!
ChrisIT ManagerAsked:
Who is Participating?
 
omgangIT ManagerCommented:
Based upon what JimD posted above I found this link
http://objectmix.com/ado-dao-rdo-rds/353825-re-access-xp-why-does-debugger-break-when-i-have-no-breakpoi.html

Give that a try.

OM Gang
0
 
omgangIT ManagerCommented:
In the VBE, have you tried Debug menu --> Clear All Breakpoints?  If the problem still persists please post the procedure and indicate where it is halting.

OM Gang
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I've seen this numerious times and it's a pain in the butt to get rid of.  I've generally find it's a result of having a break point active, then modifying the number of lines in the procedure.
I've never found a good way to clean it up either.
Usually what I do is try adding/deleting a line, then click on the offending line and toggle the break point on and off a few times.
If that doesn't do it, then I import everything into a fresh DB.
JimD.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
ChrisIT ManagerAuthor Commented:
Commenting out the line did the trick!  Thanks!
0
 
omgangIT ManagerCommented:
Orcadian, JDettman identified what the problem was.  I found the link I provided based upon his comment.  My opinion that JDettman should have received some of the points on this.

Thanks,
OM Gang
0
 
ChrisIT ManagerAuthor Commented:
OM Gang - That is very admirable of you.  I agree. Can I adjust the points, or do we need a moderator?
0
 
omgangIT ManagerCommented:
You should see a Request Attention link at the bottom right of your original post.  Click that link and ask to have a moderator change the award and the points distribution as you see fit.

Thanks,
OM Gang
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Appreciate that, but don't bother.  I really just confirmed that the problem existed.  As I said, I didn't have a good method for cleaning it up.  Importing to a fresh DB container is overkill.
JimD.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.