Access 2007 Pop up forms and the "sliver" effect

D

Damon Heron

Okay, I've googled for this and only found one posting for this strange
behaviour in Access 2007 - and no solution.
I am running a 2003 db mode and when I occasionally make changes to various
forms -not even the popup forms!- and compile, make an mde, and re-open,
some of the popup forms open as a "sliver" about 1/4" by 1/2", and it is
really hard to even close them, let alone stretch them to a readable size.
This appears to happen randomly, sometimes not at all, sometimes to one or
two forms, and sometimes to only one form.
Two ?s:
1. Anyone else experience this? and
2. Any one have ideas on how to prevent this -maybe some code in the popup
forms, or???

Thanks in advance
Damon
 
P

Paul Shapiro

Probably doesn't apply to your issue, but I had random form corruption
taking a db created from SourceSafe in Access 2003 and using it in Access
2007. The reliable solution was to open EVERY form in Access 2003 before
letting Access 2007 touch the db. I wrote a routine to automate the process
if you want to try it.
Dim frm As AccessObject 'Temporary form
Dim strFormName As String 'Name of the current form

'Open and close each form
For Each frm In CurrentProject.AllForms
strFormName = frm.Name
Select Case strFormName
Case "frmTableOfContents", "frmAbstractDialogModeDupSub"
'Don't open these forms because they generate errors when used
this way.
Case Else
DoCmd.OpenForm FormName:=strFormName, View:=acNormal,
WindowMode:=acWindowNormal
Call pjsWait(lngMilliSecs:=250) 'API code that waits 250 msec
DoCmd.Close acForm, strFormName
End Select
Next frm
 
D

Damon Heron

Thanks for your input. I have decided for now to work on my laptop, which
has 2003 Access, and complete all coding changes, etc. there before I port
it to my PC (where 2007 resides). This solves the problem with the "sliver"
forms, so I know it is something in 2007 that is causing this.
I am one of those who is not a big fan of the 2007 interface, anyway, so
this will make it less stressful. I only use 2007 because of the one nice
feature--creating a runtime version for those who don't have Access
installed. This is worth the cost of the software, in my opinion.

Damon
 

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