asked on

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!

omgang

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

Jim Dettman (EE MVE)

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.

ASKER CERTIFIED SOLUTION

omgang

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Chris

ASKER

Commenting out the line did the trick! Thanks!

omgang

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

Chris

ASKER

OM Gang - That is very admirable of you. I agree. Can I adjust the points, or do we need a moderator?

omgang

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

Jim Dettman (EE MVE)

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.