Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Forms Display (Access 2002)

    I developed an application with the intention that the Display would be 1024 X 768 pixels; after releasing the database to the end users I've notice that a few of the users have their Display set to 800 X 600 pixels. This cause a problem because I removed the Scroll Bars from the forms. Is there a way for the Application be displayed at 1024 X 768; thus overriding the Displays Setting that are set on each the work station?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Forms Display (Access 2002)

    It is possible, but I recommend not meddling with the users' display settings. I tried a resolution switching utility some time ago, and it did change the resolution, but caused flickering because it also lowered the monitor's refresh rate. See the thread starting at <post#=250795>post 250795</post#>.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Forms Display (Access 2002)

    Our experience is much the same as Hans had. One strategy you might consider is turning the scroll bars on dynamically if the display is set to 800x600. There are system calls that will tell you what the current resolution is. If you haven't, you might also want to deploy the front-end to each workstation - then you could have a configuration option for each workstation that is permanently set, and you wouldn't have to fiddle with changing form properties on the fly.
    Wendell

  4. #4
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms Display (Access 2002)

    Can you provide more details on set the Scroll Bars on "dynamically" when resolution is set at 800 X 600?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Forms Display (Access 2002)

    See ACC2000: How to Determine the Current Screen Resolution (applies to other versions of Access too). You could use the GetScreenResolution function from the MSKB article in the On Load event of a form:

    Private Sub Form_Load()
    If GetScreenResolution = "800x600" Then
    Me.ScrollBars = 3 ' both
    Else
    Me.ScrollBars = 0 ' none
    End If
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •