Pop Up form sizes are very inconsistent access 2010 (very thin)

[dstone10]

Hello,

This is only my second post on this forum but I have read posts on this forum for about 60+ hours worth of work. You guys have been more than helpful and for that I thank you.

Unfortunately my current issue I spent the last 1.5 hours googling it and have had no luck. That is why i'm registered here now and asking for help.

In my application there are 5 forms that are set up as a pop-up and datasheet view to allow users to view and edit data. They are used to editing in excel so in this particular case datasheet view was the easiest method to display all records and allow modification and keep things familiar for them.

The problem is the forms keep popping up very thin. Regardless of how many columns are displayed the form is only about 1.5 inches wide. The height is about normal.

This exact same issue happens with all of my reports.

I can resize them to make them workable but once you close the form (or report) and reopen it its right back to the small size.

This does not happen with every form I have opening in datasheet view.

What I have tried so far:

• Compared form property sheets between the working and non-working forms to make sure they are identical
• Checked the Form_Load and Form_Open code to make sure there is no code causing this behavior (no code at all on the form other than a button to print the reports)
• Added Form_Open code:

 Me.Move (0, 0, 15000, 12500)

This code did modify the height but width remained the same about 1.5 inches.

When using the code above I did disable the Auto-Resize and Auto-Center options for the form.

The button from the main form to load the datasheet form is set to:

DoCmd.OpenReport "rptMonthlySelectComplete", acViewReport, "", "", acNormal

Opening the form manually through the navigation pane or through the app produces the same results.

I'm using Access 2010, and the reason I am using the other forms in pop-up mode is because i'm launching the application but minimizing Access so it sits in the background while the application is running.

I cannot think of anything else to add to this but if you have any questions let me know. I'll look around the forums some more to find an answer and to get my post count up high enough I can post a screenshot if needed

Thanks guys!

 

[dstone10]

Not sure what the bump rules/recommendations are but it seems my post is the only one lately there hasn't been at least 1 response to.

I know its a weird issue, hopefully someone has experienced this before and found a solution.

Thanks in advance.

 

[dstone10]

WORK AROUND:

Finally found a workaround. Posting both resolutions here so someone else may find them.

The issue seems to be with multiple monitors, at least in my case and a few others I've found. On my right monitor the forms and reports opened about 1.5 inches wide total. On my left monitor they opened with an extra 1.5 inches on the right side of the form making them too large.

Whichever side the form opened on depended on which side Access was on.

To fix the issue I found some code that forces window size on load:

For Forms:

Private Sub Form_Load()
    Me.InsideWidth = 15000
    Me.InsideHeight = 10000
End Sub

Adjust your sizes accordingly.

For Reports:

Private Sub Report_Load()
    DoCmd.MoveSize 2400, 200, 12750, 14840
End Sub

That size seemed about right for a standard sheet of paper.

Hope this helps someone...spent hours trying to figure this out.

This worked in Access 2010.