Results 1 to 5 of 5
  1. #1
    Jerry8989 is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    27

    Question resizing form based on resolution

    I'm trying to find a way to dynamically resize my forms based on the users monitor resolution.

    I tried using the demo of ShrinkerStretcher. Which works but on my normal monitor it doesn't show up correctly. The words are blurry.
    http://www.peterssoftware.com/ss.htm




    What would be the best way to do it using VBA? When the project started they said everyone would have the same monitors and resolution. Now that we are about to release all that has changed and now i'm scrambling to figure this out.

    Thank you for any help

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    When developing applications you should always think about the minimum screen resolution that the app will run under and size accordingly. Also ensure that your startup position is Centre of screen.

    David

  3. #3
    Jerry8989 is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    27
    dcrake,
    I agree that the lowest resolution is where I would have started but I was told originally that everyone was using 19 inch monitors with resolution of 1280 x 1024. This app is only going to be used by 10 or so people originally. Now there is much more and not just at my location there will be people using it from other locations.

    I just changed my resolution here to what I think will be the lowest and I'm working on getting everything to fit on the screen.

    Thanks for the help

  4. #4
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    Thats the problem when the developer has got a nice big monitor with plenty of memory and high spec CPU. You can never really bench test it on a bog standard machine. Remember those who provide system specs always lie. Don't take everything for granted.

    David

  5. #5
    Jerry8989 is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    27
    David,
    LOL
    You are exactly right. Live and learn.

    Thank You

Please reply to this thread with any new information or opinions.

Similar Threads

  1. filter form based on combo box
    By lloyddobler in forum Forms
    Replies: 8
    Last Post: 09-10-2009, 07:33 AM
  2. Adjusting Form size based on screen resolution
    By stombiztalker in forum Forms
    Replies: 0
    Last Post: 02-17-2009, 07:18 PM
  3. Form Based Query/Filter
    By Micon in forum Access
    Replies: 0
    Last Post: 11-07-2008, 09:25 AM
  4. Run a PivotChart form based on query
    By Suzan in forum Queries
    Replies: 0
    Last Post: 06-11-2006, 03:48 AM
  5. Open form based on Subform criteria
    By Suzan in forum Programming
    Replies: 0
    Last Post: 04-25-2006, 02:28 PM

Tags for this Thread

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