UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Form To Fit Screen, Access 2013    
 
   
johnnyenglish775
post Nov 29 2017, 08:58 AM
Post#1



Posts: 26
Joined: 27-November 17



Hello,

There are different monitor sizes here and I was wondering if there is a way to auto fit the forms to fit the screens.

Does anyone know how please?

Thank you for any help or suggestions.
Go to the top of the page
 
GroverParkGeorge
post Nov 29 2017, 09:08 AM
Post#2


UA Admin
Posts: 31,201
Joined: 20-June 02
From: Newcastle, WA


There have been attempts to automatically adjust forms with VBA, and some of them work reasonably well.

However, one good approach that takes less work would be the tabbed documents interface instead of overlapping windows.

Or are you only thinking in terms of the position of controls within forms?

--------------------
Go to the top of the page
 
johnnyenglish775
post Nov 29 2017, 09:11 AM
Post#3



Posts: 26
Joined: 27-November 17



I am thinking of a fit to screen scenario if possible.
Go to the top of the page
 
johnnyenglish775
post Nov 29 2017, 09:13 AM
Post#4



Posts: 26
Joined: 27-November 17



I suppose another option would be to customize each front end version for the applicable monitor sizes. Thank you for helping.
Go to the top of the page
 
GroverParkGeorge
post Nov 29 2017, 09:19 AM
Post#5


UA Admin
Posts: 31,201
Joined: 20-June 02
From: Newcastle, WA


"...fit to screen..." as in move/resize controls on the form?

--------------------
Go to the top of the page
 
johnnyenglish775
post Nov 29 2017, 09:22 AM
Post#6



Posts: 26
Joined: 27-November 17



I thought I had all the settings to autosize but it doesn't seem to work. Maybe it has to be done in VBA not sure.
Go to the top of the page
 
johnnyenglish775
post Nov 29 2017, 09:24 AM
Post#7



Posts: 26
Joined: 27-November 17



George this is the way it looks on one monitor. It has blank space on the right and bottom now.
Attached File(s)
Attached File  Switchboard.png ( 42.55K )Number of downloads: 8
 
Go to the top of the page
 
DanielPineault
post Nov 29 2017, 09:57 AM
Post#8


UtterAccess VIP
Posts: 5,451
Joined: 30-June 11



Review http://www.devhut.net/2017/09/08/access-fo...een-resolution/ perhaps it can offer a solution.

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 
johnnyenglish775
post Nov 29 2017, 10:24 AM
Post#9



Posts: 26
Joined: 27-November 17



Thanks for the tips but I haven't been able to find a solution yet that is without a charge. They are not willing to pay for anything here so it is out of my control.
Go to the top of the page
 
GroverParkGeorge
post Nov 29 2017, 10:38 AM
Post#10


UA Admin
Posts: 31,201
Joined: 20-June 02
From: Newcastle, WA


I'm sure Daniel doesn't charge for anything on is site. And there is never a charge for anything available here, so maybe that's the way to go.

--------------------
Go to the top of the page
 
DanielPineault
post Nov 29 2017, 10:45 AM
Post#11


UtterAccess VIP
Posts: 5,451
Joined: 30-June 11



There are numerous free examples (with full code) provided in the prior link.

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 
johnnyenglish775
post Nov 29 2017, 10:47 AM
Post#12



Posts: 26
Joined: 27-November 17



I have not found one to work yet but thanks.
Go to the top of the page
 
GroverParkGeorge
post Nov 29 2017, 12:49 PM
Post#13


UA Admin
Posts: 31,201
Joined: 20-June 02
From: Newcastle, WA


"...and some of them work reasonably well."

But none that I know of is perfect.

--------------------
Go to the top of the page
 
DanielPineault
post Nov 29 2017, 01:01 PM
Post#14


UtterAccess VIP
Posts: 5,451
Joined: 30-June 11



QUOTE
I have not found one to work yet but thanks.

iconfused.gif


These all come from the article previously provided.


I've personally used the 1st on a couple occasions and had no issues.

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    13th December 2017 - 03:56 PM