Break Occuring with no Break Point

  • Thread starter Scrabble.Devotee
  • 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?
 
J

Jennifer

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
 
K

Klatuu

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top