Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Templates > Form Profile Template >
Access Form Profile Template

Many Profiles for Different Screen Sizes, Colors, Etc.

 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now

Do you want to make it easy for users with different screen sizes to be able to work with your database? This template allows you to set up custom profiles optimized for different screen sizes, color profiles, visible controls, and lots more. Watch the free Introduction and Feature Walk-Thru videos, and see below for complete details. 


Sample Database

If you'd like to download a sample copy of the database template, you can do so here. This is a non-editable ACCDE version of the template which will let you see it work in action. You can switch between the different form profiles that I have designed, but you cannot change them, or access the design of the forms, reports, VBA, etc. The sample database requires 64-bit Access 2013 or higher. If you're still using 32-bit Office, read this. Be sure to watch the Introduction and Feature Walk-Thru videos (above) to see how to use it.

Full Developer Database

Once you have purchased the full developer database template, come back to this page and click on the Download button below. This will give you access to the ZIP file containing the Template ACCDB file. The full version will run on 32-bit or 64-bit Access 2007 or higher. Be sure to watch the User Guide video (above), and visit the Instructions page. The Developer Notes video is only for those people who are brave enough to attempt to modify my template. Good luck. LOL.

Please be sure to read the Before You Purchase section below before buying this template!

Order Now


  • Create Multiple Forms for Different Screen Sizes, Color Schemes, Users, etc.
  • Complete Profile Selector and Editor
  • Load, Change Design, Save Profile Configuration
  • Control Profile Loading on Startup via Command Line Switch

Introducing the Form Profile Template brought to you by Access Learning Zone. My name is Richard Rost. Do you want to make it easy for users with different screen sizes to be able to work with your database? This template allows you to set up custom profiles. You can set up special color options, different visible controls, and lots more. This template takes the existing forms in your database and allows you to save and load different versions of them. All the template does is modify the properties of your form and the controls in them. For example, here you see four different profiles for the same standard customer list.

A normal version in both blue and purple on the left, the green cell phone layout in the middle. That's great for remote users who maybe use it on their phones or their tablet devices logged in. And the big red one over on the right is for the power user. With that huge monitor on its desk. Again, this is the same form. So you only have to make design changes to one form. You only have one set of VBA code to worry. You just save multiple profiles for each form.

Here's a different form. The customer form, you see a black and white high contrast version in the upper left, below that a regular blue version. And below that one, a purple version, same form, different profiles. Here it's just different colors.

Some users like to make their own color palette changes, or if their hard of seeing they might want the high contrast version. Or you could have a manager version in purple that shows things like the credit limit and the blue version. For example, for the normal sales people, doesn't show that there's the little green cell phone version on the bottom. And to save space, you can show or hide different fields on each profile, if you want to. And finally up top is the big monster red version for the person with a huge monitor. You can either make the fields bigger. So they're easier to read or just cram a lot more stuff on each screen. The choice is yours.

There's a profile editor form, for the database administrator here. You can make design changes to the form and save them as a particular form profile. Then you switch profiles, load up that. And do it all over again, make as many profiles as you like.

You can allow the user to select which profile they want when the database loads, or you can set a default profile in the settings table.

If you prefer, you can also control which profile loads up by preparing a custom shortcut for each user. The choice is yours.

This template also includes my zoom tool. So if all you want to be able to do is make your forms bigger or smaller by zooming in and out, you can do that as well, without having to set up a custom profile.


Order Now

Before You Purchase

A few important notes before you purchase this template:

  • Please note that this is NOT a teaching database. You should have a strong background in developing Microsoft Access applications before attempting to setup this template with your database. You don't have to be an expert with Visual Basic, but you should know a little VBA. I strongly recommend taking my Access Developer 1 course first or at a bare minimum watching my Intro to VBA video. 
  • In order for this template to work properly, you must follow the instructions in the User Guide video (#03, above). I have written some of them out below, but be sure to watch the video and follow it carefully so that everything works OK in your database. If you post a comment saying that it's not working, and you didn't follow the steps, I'm going to say "I told you so."
  • Backup. Backup. Backup again! Be sure to test this on a backup copy of your database first!
  • This template will only work with forms that have zero or one subform controls. Forms with two or more subforms are not supported. Yet. If there is enough interest, I can add that in the next version.
  • Remember, we do our best to help you here in the Forums on the website, but technical support is not guaranteed.

Possible Future Upgrade Ideas

If you are interested in any of these, please post a comment below.

  • Support for multiple subforms
  • More developer-friendly form profile setup


For internal use only. This template does NOT come with a royalty-free license. You may only customize the template for your business needs and for use within your organization at one location ONLY. You may not resell or distribute any form of this template to others without express written permission. Contact me for additional information on obtaining a license to distribute if you plan on including this template in a product you are reselling. Additional licenses are required if you plan on using this template with more than ten (10) employees or in multiple locations within your organization.

Not a Finished Product

Please keep in mind that most of my template databases are not designed to be finished products that are ready to go in a working environment. My templates are meant as starting points for you to customize for yourself so you don't have to reinvent the wheel. This requires that you have a basic understanding of Microsoft Access development. To work on most of my databases you should have completed my Access Beginner series and the first couple levels of my Expert series at a minimum. Most of my databases require knowledge of SQL and VBA as well. 

Customize For Your Needs

If you would like to discuss customizing this template for your needs, and integrating it into your current setup, please see my consulting page for details. While I no longer accept custom jobs that are specific to a single user, I may include your features in a future version of this template if they have mass appeal. If you are looking for custom enhancements made to this template just for you, visit my Developer Network.

Technical Support

Please note that technical support is NOT guaranteed for any of my courses, seminars, or templates. If you require help with modifying this template, you may post a question in the Forums, however an answer to your question is not guaranteed. If this template comes with an accompanying Seminar, then you should purchase that Seminar to see how the database was constructed. If not, then you should have taken the suggested courses. Most of my templates are designed on a Developer level and you should have a thorough understanding of SQL and VBA before attempting to modify them. If you have a problem with one of my databases, I will only support the unmodified database exactly as it's downloaded from my site. If you have modified it in any way, it may not be something I can help you with. You can post in the Forums, and I may be able to help you, but if the issue doesn't exist in my unmodified database, it's not something I can support.


Got sales or customer service questions about this template? Feel free to contact me. If you have technical "how do I" questions about this template, you discover a bug, or want to suggest a new feature, then please post your comments below.


microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #template, form profile editor, different screen sizes, zoom in, zoom out, form zoom level, Access Forms using with different screen resolutions, Access Form Resizing Based on Screen Resolution, zoom access forms, zoom access forms, automatic form resizing, form resizer, dynamically resize forms and controls


Comments for Access Form Profile Template
Age Subject From
12 monthsSupport for Multiple SubformCarl Byerley
12 monthsForm Profiles Zoom FeatureCarl Byerley
2 yearsAccess Form Profile TemplateHoward Chapell


Start a NEW Conversation
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
Subscribe to Access Form Profile Template
Get notifications when this page is updated

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/4/2024 3:29:06 PM. PLT: 0s
Keywords: templates access form profile editor, different screen sizes, zoom in, zoom out, form zoom level, Access Forms using with different screen resolutions, Access Form Resizing Based on Screen Resolution, zoom access forms, zoom access form  PermaLink  Microsoft Access Form Profile Template