Screen Resolution 2

[fileman1]

After all this time, and all money spent on versions, Access still does not cater to different screen resolutions.

I have to do a form for someones laptop, 1366x768. My laptop is 1280x768. They also have a PC for which I cannot match resolution.

Is it feaseable to have a popup full screen form that has command buttons allowing the user to move 4 boxes to the extreme corner positions, and saving their positions in a table. I can then get it back and use as a template. Would it work?

 

[dhookom]

There are a number of free screen resizing utilities available for MS Access. You can also try code something like:

Private Sub Form_Resize()
[COLOR=#4E9A06]    'Assumes a rectangle control named boxFull[/color]
    Me.boxFull.Top = 0
    Me.boxFull.Left = 0
    Me.boxFull.Width = Me.InsideWidth
    Me.boxFull.Height = Me.InsideHeight
    Dim strSQL As String
    strSQL = "INSERT INTO tblYourTable(...) VALUES (....)"
    CurrentDb.Execute strSQL, dbFailOnError
End Sub

I had the scroll bars, record selector, and navigation turned off.

Duane
Hook'D on Access
MS Access MVP

 

[fileman1]

Thanks Duane, looks a good way to do it, however I know it's not good to have so many controls on a form, but I have. The thought of entering every single position relative to either another control or form dimension would take so long?
Just surprised Microsoft knowing the problem all this time has not built something in.
I did look around for freeware solutions but only came across Peters purchasable Software. I just guessed If I had some visual guide of how dimensions could be then I would bite the bullet and rescale everything manually. Regards

 

[dhookom]

I typically create forms based on the least resolution and have never had anyone complain.

I don't know if your second sentence is a question or not.

Duane
Hook'D on Access
MS Access MVP

 

[missinglinq]

Creating Forms based on the lowest resolution likely to be used is the best policy, as Duane suggested, even if you plan to use a re-sizing hack. All such utilities that I've come across say, in their instructions, that they work best when up-sizing to greater resolutions than in trying to down-size.

Here's a link to one such utility that I've used, without problems, for a number of years:

Form Resizer

It's a shareware program, with the authors simply asking for a $5 or $10 donation, if you find it of use.

The Missinglinq

Richmond, Virginia

The Devil's in the Details!

 

[fileman1]

Many thanks, that looks worth trying. Sorry to Duane delay coming back, only just come back on forum.
So thanks both, I will try that out.