Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328

    Form_Increase Size

    We are using Access 2003. One computer with 2007. Is it possible to increase a form's size without going into the design mode and changing field sizes?. One user has some vision problems and has a screen that would allow the forms to be almost twice as big as designed. It would help him much to make the form larger.



    If not possible with Access, some other way?

    Any help much appreciated.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    can he hold the CTL key & zoom in with the mouse wheel?

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by gg80 View Post
    We are using Access 2003. One computer with 2007. Is it possible to increase a form's size without going into the design mode and changing field sizes?. One user has some vision problems and has a screen that would allow the forms to be almost twice as big as designed. It would help him much to make the form larger.

    If not possible with Access, some other way?

    Any help much appreciated.
    Have you considered using Windows Magnifier. See: https://support.microsoft.com/en-gb/...-easier-to-see
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    My automatic form resizing code also includes an option for individual users to zoom an individual form.
    Detailed instructions and all required code can be found at http://www.mendipdatasystems.co.uk/a...g-1/4594554784
    The zoom feature is on the second page of the article.

    Note that although the underlying code is complex, using it is very simple
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    Tried and doesn't work. Thanks for the reply, much appreciated

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Saying 'tried and it doesn't work' is unhelpful.

    I know it does work and many other developers also use this code.
    If you provide further explanation, I may be able to assist
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    Quote Originally Posted by Bob Fitz View Post
    Have you considered using Windows Magnifier. See: https://support.microsoft.com/en-gb/...-easier-to-see
    I tried it and have to mess with it a while to do what I need. Find it a little confusing, but I am sure that it will do the job as I finally get how to use it. Thanks much.

  8. #8
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    Quote Originally Posted by isladogs View Post
    Saying 'tried and it doesn't work' is unhelpful.

    I know it does work and many other developers also use this code.
    If you provide further explanation, I may be able to assist
    I hold down ctrl key and roll the mouse button On a form with list of records it scrolls the record. On single record display, just moves from field to field.

  9. #9
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    That was Ranman's suggestion-not mine.

    That's not how my form zoom code works.
    Did you bother to read the article? Did you actually use the code supplied?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  10. #10
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    Sorry that I sent you the note intended for Ranman. I did read all of it and gave it a try today. I then copied and pasted the code in my program, but I am doing something wrong and will work on it again on Monday. I got an error message. Part of the problem may be that while I have put together some Access projects using VBA, I am not "sophisticated" . If I can't fix the problem , I would like to contact you again if OK. Even better, if you had a simple example that works, I would love to get it.

    Thanks again for responding.

  11. #11
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    Quote Originally Posted by ranman256 View Post
    can he hold the CTL key & zoom in with the mouse wheel?
    I hold down ctrl key and roll the mouse button On a form with list of records it scrolls the record. On single record display, just moves from field to field.

  12. #12
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by gg80 View Post
    Sorry that I sent you the note intended for Ranman. I did read all of it and gave it a try today. I then copied and pasted the code in my program, but I am doing something wrong and will work on it again on Monday. I got an error message. Part of the problem may be that while I have put together some Access projects using VBA, I am not "sophisticated" . If I can't fix the problem , I would like to contact you again if OK. Even better, if you had a simple example that works, I would love to get it.

    Thanks again for responding.
    The website article included an example app ResizeFormExample v2.6 which I'm attaching here
    However that contains lots of additional code not relevant to your needs.
    So I'm also including a cut down version ZoomForm.

    This opens to a very simple popup form frmPopupZoom. You can zoom this with the slider control or using the combo

    Click image for larger version. 

Name:	PopupZoom.PNG 
Views:	19 
Size:	84.2 KB 
ID:	42672

    The app also includes a more complex form frmExample3 using the same zoom feature

    To use this feature in your own apps, you need to import the module modResizeForm.
    Use code like that in frmPopupZoom (or import the form to your app and modify it for your own purposes)

    NOTE: The feature works better if you use overlapping windows display in Access options
    Hope that helps
    Attached Files Attached Files
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  13. #13
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    When I try to open what you sent, I get the message "Unrecognized data base format 'C: etc." Is this written for Access version beyond 2007? I really appreciate the time you have put into this.

  14. #14
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Sorry. All my apps are created in A2010 or A365 and in some cases users of A2007 will get an error.

    I've converted it to a A2003 MDB file then re-saved that as an A2007 ACCDB file using a virtual machine.
    Both are included in the attached zip file

    Hopefully the frmPopupZoom form will work reasonably well though its not as smooth as the original
    The other form had an application error which I haven't tried to fix - busy on other tasks
    Attached Files Attached Files
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  15. #15
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    I tried the program today, couldn’t resist. There is a problem. It works beautifully if don’t do anything else. But, if I go into the design mode (even without looking at code) then go back to form view, get this message :
    Run Time error 5: Invalid procedure call or argument
    If close message and try to change pull down value, get message:
    Error 11 in cboZoom_AfterUpdate procedure: Divide by 0
    I tried to look at the code, but, as I said, I can do VBA, but this one is beyond me. I know that you have done a lot already and understand if you have had enough. Hope you have time to fix.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 12
    Last Post: 10-21-2018, 05:49 PM
  2. Size of Access Window set to Fom size
    By MrDummy in forum Access
    Replies: 2
    Last Post: 06-26-2016, 05:18 AM
  3. Replies: 4
    Last Post: 02-10-2015, 01:07 AM
  4. Replies: 2
    Last Post: 03-20-2013, 04:25 PM
  5. Replies: 3
    Last Post: 07-19-2012, 09:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums