Hi, I started today to use Access 2016 on a new computer (HP, windows 10) and I am encoutering a problem which did not occure on my old computer (also HP, windows 10). I use Office 365.The size of the boxes of the boolean character fields are out of proportions and pixellised. They change size if I change the width of the fields, but I have to reduce at the max the width of the fields in order to get a normal box size and as a result I cannot read the title of the fields. I have checked my computer display setting, it's at 125% which is what is recommended by Windows 10. I have contacted the online support of Microsoft and the agent took over my computer to uninstall and install again Office 365, it did not change anything. As anyone ever encoutered this problem and found a solution ?

Belisaire Is that a form or a table/query?Check your error trapping settings in the Visual Basic Editor.The only time I've seen anything similar was when the setting was Break On All Errors.If that is the case, change to Break On Unhandled Errors If its a form and that doesn't help, try decompiling your project: Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption (fmsinc.com)

isladogs thanks for your message. I have checked the Visual Basic Editor but the setting is already on "Break On Unhandled Errors".The picture I am showing is from a table. However, I must precise : this disturbing display of Boolean fields boxes occures anytime on Access, even on new database. It does not happen on my old computer... so could it be a problem of PC resolution ? My new PC has a higher screen resolution than the former. But I'm sure plenty of Access users have even far better computer than mine, so I do not get why this problem is happening.

Does it still happen if you create a form or report based on the table?It mat be that there is an Access client setting on the new computer that is triggering this behaviour but I'm not sure what that would be. See if you can see any differences between the client settings on the two computers

If I create a form or a report based on the tables with Boolean fields, the boolean fields will have normal size boxes in the form or report...I have made a comparison between the Access client setting on my new computer and the old one, but they are strictly the same since I use Microsoft 365 with both.

I should have asked you to check the appearance in a query and in a datasheet form as well.The only other option settings I suggest you check are those for object designers and datasheets... but I'm not too optimistic that either will provide a solution.Of course, I could say it doesn't matter as end users should never look at tables or queries directly. All interaction should be done using forms. Whilst that is true, I would also want to determine the cause. Have you tried compacting?

Problem display size boolean fields | Microsoft Community Hub

isladogs
MVP
Aug 17, 2021
Belisaire
Is that a form or a table/query?
Check your error trapping settings in the Visual Basic Editor.
The only time I've seen anything similar was when the setting was Break On All Errors.
If that is the case, change to Break On Unhandled Errors

If its a form and that doesn't help, try decompiling your project: Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption (fmsinc.com)
- Belisaire
  Copper Contributor
  Aug 18, 2021
  isladogs thanks for your message.
  
  I have checked the Visual Basic Editor but the setting is already on "Break On Unhandled Errors".
  The picture I am showing is from a table. However, I must precise : this disturbing display of Boolean fields boxes occures anytime on Access, even on new database. It does not happen on my old computer... so could it be a problem of PC resolution ? My new PC has a higher screen resolution than the former. But I'm sure plenty of Access users have even far better computer than mine, so I do not get why this problem is happening.
  - isladogs
    MVP
    Aug 18, 2021
    Does it still happen if you create a form or report based on the table?
    It mat be that there is an Access client setting on the new computer that is triggering this behaviour but I'm not sure what that would be. See if you can see any differences between the client settings on the two computers
isladogs
MVP
Aug 20, 2021
Sorry. Did you mean you had already checked for an updated graphics driver?
- Belisaire
  Copper Contributor
  Aug 21, 2021
  I have a brand new PC, which is fully updated. I guess perhaps I don't know what you mean by "an updated graphics driver".
  - isladogs
    MVP
    Aug 21, 2021
    Belisaire
    The graphics driver is software supplied with your computer which controls the display from your monitor. Periodically, updates may become available which you can download.
    
    From the taskbar, go to All Settings ...Windows Update...then check for updates.
    You may see a list of optional updates for various hardware drivers. For example, mine currently looks like this:
    
    As you have a new PC, there may not be any optional updates available for download.
    Anyway investigate that and if you still have the issue, feel free to upload a cut down copy of your database showing the problem

Forum Discussion

Problem display size boolean fields

Share

Resources