Deleted label freezes application

[Todd M]

Hello - I'm modifying reports in a stockholder database I built using Access
2003 on an Exchange 2007 network at the bank where I work. Recently (last
couple of months) when I add a field from the field list to an existing or
new report, I often need to delete the associated label. Selecting the label
and pressing delete works fine, as it always has before, but every time I do
it, the Access application freezes up -- the toggle between preview and
design mode will not work when I click on Preview, and I have to shut down
the database and lose my changes --every time. In order to get the report I
need, I've had to leave the label in the report, shrink it down, and make it
invisible in order to get the report to work. The existing reports (built by
me) are already comprised of text boxes largely without labels, so it makes
no sense. My reports are collecting a garbage pile of hidden labels. Any
ideas on why this is happening, when it wasn't happening previously? Thanks
in advance.
-- Todd

 

[Allen Browne]

Todd, this is an interesting observation.

Someone else made a similar observation regarding Access 2003 after SP3 was
applied. IIRC, they said the crash only happens if this is the last thing
they do before saving/closing the report out of design view. Does it make
any difference if, after deleting the label, you then go and set a property
for a text box (e.g. changing its Width to the same value it already had)?
Or does you experience the freeze before you can do that?

 

[Todd M]

Allen:
Thanks for the response. Ther freeze-up is immediate -doesn't seem to
matter when I do it. However, yesterday, I successfully deleted the piled-up
unwanted labels on the existing report without incident, after weeks of
trying, and as though there had never been a problem. It was the first
action I took after opening the DB. Simply selected the labels (about 8-10
of them) and pressed "delete" - just like all the times before -- no problem,
toggle to preview worked fine and file saved and re-opened OK. Can't
explain... sure leaves me skeptical, after years of successful use of Access.