FormResize locks up on PivotChart

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a form that uses the FormResize class from the Getz and Litwin
Access 2000 developers handbook. I recently upgraded to Access 2003
and began using pivot table and pivot chart form views. However, any
time I this feature in conjunction with FormResize, the app locks up
and never returns. This is the code that locks it up:

Set frmResize = New FormResize
Set frmResize.Form = Me

Anyone have a work-around for this?

Thanks in advance for your help. --Mike
 
Answered my own question. For those with the same problem, you need to
modify ScaleFormContents to exclude pivot tables and charts as follows:

Change this:
If frm.CurrentView = acDatasheetView Then...

To this:
If frm.CurrentView = acDatasheetView Or frm.CurrentView = 3 Or
frm.CurrentView = 4 Then...
 
Back
Top