Break Occuring with no Break Point

  • Thread starter Thread starter Scrabble.Devotee
  • Start date Start date
S

Scrabble.Devotee

I'm not sure what's happening here, but a break is occuring with no
break point in sight. I'm using Access 2003. The database is used by
one person. I was asked this morning to make a couple of cosmetic
changes to a spreadsheet which is the output of a macro. I did so and
tested and all looked fine. I set some break points while testing and
removed them when I was done. A while later my user sends me a screen
shot of the macro code and one of the lines is highlighted in yellow -
like a break. Ok, so I open up the database, click on the button that
runs the macro and sure enough, the code comes up as if a break point
were set. I was able to hit the F8 button to start stepping through
the code and then clicked the "run" button and everything went on it's
merry way. So I cleared all breakpoints, saved the form and closed
the database. I opened it up again, ran the macro and all was good.
My user tried it and she was still having the same problem. I don't
know what else to try here. Any suggestions?
 
I found the fix to the "Phanton Breakpoint". In case anyone is
interested, run teh Compact and Repair command from the Tools menu.

Thanks,
Jennifer
 
You only thought you cleared all the breakpoints before saving.
Open the VBA code window, clear all breakpoints, and compile your code.
Then do a compact and repair.
It will go away.
 
Back
Top