Resize Microsoft Access Forms for Different Screen Sizes & Resolutions Using Anchoring. Zoom In/Out.
ฝัง
- เผยแพร่เมื่อ 14 ก.ย. 2022
- In this Microsoft Access tutorial, I'm going to teach you how to use Anchoring to allow you to resize the controls on your form to fit different screen sizes. This way you can see more information on larger screens, but still design your forms to fit on smaller ones like cell phones. As a bonus feature, I'll teach you how to automatically maximize forms when they open to take full advantage of your screen space.
Brennan from Cork, Ireland (a Platinum Member) asks: I have three different devices that I use my database on. I have my normal desktop PC in my office. I have a travel laptop that's got a much smaller screen. I also like to log on remotely using Remote Desktop software to check things from my cell phone. I've built three different sets of forms for each of these devices, but it's a pain having to update them. Every time I make a change to one, I've got to change all three. Isn't there any way you can stretch or resize forms to fit the available screen space?
Silver Members and up get access to an Extended Cut of this video. Members will learn how to build buttons to allow a user to actually zoom in and out of an Access form and resize the controls and font sizes. This is functionality that is in Word, Excel, and PowerPoint and should be in Access, but it's not. However, we can add it with a little bit of VBA coding.
MEMBERS VIDEO:
• Resize Forms MEMBERS O...
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
Assign Email: 599cd.com/ResizeForms
PRE-REQUISITE:
Blank Template: 599cd.com/Blank
RECOMMENDED COURSE:
Access Beginner 1: 599cd.com/ACB1
LINKS:
Intro to VBA: 599cd.com/IntroVBA
ShrinkerStretcher: www.peterssoftware.com/ss.htm
Access Form Profile Template: 599cd.com/FormProfile
Access Developer 41: 599cd.com/ACD41
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Access Forms using with different screen resolutions, Access Form Resizing Based on Screen Resolution, Shrinker, Stretcher, Zoom in, zoom out, zoom in access forms, zoom out access forms, automatic form resizing, form resizer, dynamically resize forms and controls, DoCmd.Maximize, multiple monitor sizes
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
![ลักพาตัว เอาลูกเอิร์นกลับมา...!! [เอิร์นไดเม่]](http://i.ytimg.com/vi/f4NVKlZ5qkk/mqdefault.jpg)
Thank you Brennan for asking the same question that I've been browsing youtube for the answer for days. The db I developed does not show the same on different screen of desktop, laptop. Thank you Richard for always finding the solution for our problems. There was one time, I was already half sleeping fortunately realized that I forgot to give a thumb up after learning Richard's lesson, I had to turn on the light the laptop to thumb up Richard's hard work and I saw Richard smiling in my dream. :-) You're the greatest teacher Richard. Thank you!
Haha. Thanks.
Thank you so much sir, been trying to make my forms responsive, although its very stressful having to resize each elements of the forms with condition based on the screen size. I think this anchoring solves it to a large extent.
Happy to help
Nice, I've never seen this anchor ⚓ feature before.
I've never seen that anchor emoji before! :)
🙏🙏🙏🙏🙏🙏🙏
Thank you for your excellent, most wonderful explanation
Welcome
I like putting buttons on bottom of form for navigation, close current and open new/next form. I generally use footer for this, allows me to control flow, yes I am a control freak...lol.
Yep. Me too.
9:27 say I want the zipcode box to also resize with the form in addition to the city box and the state box should remain the same how would I do that? I cant seem to figure out how to make 2 boxes resize with one box that does not resize in between the 2 resizing boxes.
I guess the right question to ask is how to scale the form to auto fit the display when loading. This is informative but it won't fix the problem of form loading in different scale. Even if you have same display settings and monitor size. And other settings (Keyboard. Language. Font) sometimes access just load the form in different scale.
Yep that's covered in the Extended Cut
Saw ad for auto report execution software, think this would be good project to develop and something useful to your viewers. Something simple, indepth could be bonus or possible seminar. Schedule by day, week, month, quarter, semiannual, annually or request.
Texting is challenging for me due to double vision from stroke 5 yrs ago. Retired. Former mainframe programmer, cobol selftaught. Selftaught in Access and other areas as well. First puter was TI99/4A, 16 bit machine.
I don't know what you mean by "auto report execution software." Can you elaborate? Contact me at 599cd.com/CF as I don't check TH-cam often. And yea, I feel you... I lost vision in one eye a few years back, and my "good" eye ain't that great.
Auto repot gen: was an ad I saw that discussed software used to schedule report execution to automate reports one would normally execute manually per a schedule.
Hello , where are the membership link please
You should see a blue JOIN button. If not, go here: 599cd.com/THM
I didn't know the anchoring thing was even there. And I now know it's been around for awhile, but why couldn't they have made it more like the grid system used in CSS (minus all the coding work one has to torcher themselves with? I know I know you just teach us you didn't make it but.
It's been there for a few years. I rarely use it myself.
exilent sir,
Why are 98% of my tutorial gears
Huh?
@@599CD Sunil might have meant "Yours" but something got lost in translation. And I can answer the why. CLZ's tutorials work. No hard to grasp accent or poor audio quality usually. Often gets to the point. Can see VBA code when used instead of image of the guy who made the video imposed in somewhere on the screen and his/her image covers the part fo the code you absolutely need. There are others tutorials. Many not that good. What I'd like is one that automatically resizes everything including the fonts (found a video and had a link to code - but when I use the code it fails on me. If I use the demo the person has a link to - guess what it works.)