Results 1 to 14 of 14
  1. #1
    chrisleng is offline Novice
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    19

    acCmdZoomBox opens with font size 1 on some Office365 installs

    Some users who we've recently upgraded to Office365 business standard are now experiencing an issue where their acCmdZoomBox loads with font size one and is un-readable, I'm unsure what's caused this issue or how to work around it,



    thanks

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The only time its happened to me was after I changed the settings & forgot to restore the previous values

    When the Zoom box opens, click the Font button and change the font size to whatever you want e.g. 12.
    You can also change the font style and name if you want.
    The changes will 'stick' even after Access is closed and will still be there in a new session
    Last edited by isladogs; 01-27-2022 at 04:40 AM.
    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

  3. #3
    chrisleng is offline Novice
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    19
    That's part of the problem, on the effected PCs the font button causes a crash to desktop

  4. #4
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Hmm I've read about that somewhere... But I can't find a reference to it

    Nearly this https://support.microsoft.com/en-us/...e-af0b57d3fa0d
    but not quite.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    chrisleng is offline Novice
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    19
    Quote Originally Posted by Minty View Post
    Hmm I've read about that somewhere... But I can't find a reference to it

    Nearly this https://support.microsoft.com/en-us/...e-af0b57d3fa0d
    but not quite.
    Yea, this is not the ZoomBox itself, this is just the font settings within it, which are currently set to an un-usable setting, so we need to be able to get it to open without an error to sort it

  6. #6
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    I wonder if this code might help you force the size? https://bytes.com/topic/access/answe...-font-zoom-box
    It refences A2003, I doubt if it will still work, I don't know where the Zoom box properties are stored these days.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  7. #7
    chrisleng is offline Novice
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    19
    Quote Originally Posted by Minty View Post
    I wonder if this code might help you force the size? https://bytes.com/topic/access/answe...-font-zoom-box
    It refences A2003, I doubt if it will still work, I don't know where the Zoom box properties are stored these days.
    I had tried this one before and access just doesn't recognise the reference, just get "variable not defined" error

    utility.zoom_iFontSize = 24

  8. #8
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    That a pain.
    On a troublesome machine, If you create a new access database and a single table and enter some data and press the zoom box does it still crash?

    Edit - if it's still playing up you could switch over to a custom zoom box : https://www.vb123.com.au/200602_mt_zoom.htm
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  9. #9
    chrisleng is offline Novice
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    19
    Lol, yea, that's the fix I've come up with, for users with issues i've made a 1 form database compiled with Access365 that does work and sets the default for their PC that then sticks for the troublesome database, as one of my guys said "oh god, that's such a bodge" :-)

  10. #10
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  11. #11
    chrisleng is offline Novice
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    19
    Quote Originally Posted by Welshgasman View Post
    Thanks

    I ended up using the ugliest hack to sort this, I put a small "fix" button next to the zoombox button, it opens a totally separate database with 1 form with a zoombox button, the Font button works there and allows changing the default for Access to be a usable ZoomBox again, users only have to use it once but it's still such a bodge!

  12. #12
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Thanks for posting your workround on both sites
    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
    chrisleng is offline Novice
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    19
    I didn't realise both sites were so closely linked, or just not all heroes wear capes

  14. #14
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The sites are not linked at all though many helpers visit multiple sites on a regular basis.
    That's why it is always appreciated when members state if they have crossposted, provide a link AND provide a follow up at resolution (as you did)
    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

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

Similar Threads

  1. Replies: 12
    Last Post: 01-12-2019, 06:02 PM
  2. Anyway to increase font size
    By GraeagleBill in forum Access
    Replies: 1
    Last Post: 04-16-2018, 09:35 PM
  3. UI Font Size
    By bertsirkin in forum Access
    Replies: 4
    Last Post: 06-23-2017, 07:24 PM
  4. Treeview font size
    By charly.csh in forum Access
    Replies: 7
    Last Post: 03-23-2016, 05:09 PM
  5. MsgBox font size
    By GraeagleBill in forum Programming
    Replies: 4
    Last Post: 01-02-2013, 02:59 PM

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