Results 1 to 14 of 14
  1. #1
    jsblume is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    20

    Checkboxes in Query Designer and Table View


    I have Office Professional 2019. I recently upgraded to Win11. If I open a table to view the data or create a query using the query designer, the Yes/No fields show up as a checkbox with a blue background. They previously had a white background.

    I'm sure this is something with Win11, but I'm hoping someone here might have some thoughts for how to change it back.

    Thanks!
    Click image for larger version. 

Name:	MS Access Yes-No Field in Query Designer.png 
Views:	18 
Size:	2.8 KB 
ID:	46973

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    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

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,740
    I'm sure this is something with Win11, but I'm hoping someone here might have some thoughts for how to change it back.
    I think you have up to a week's option to change back to Windows 10, if you feel that's really a sufficient reason.

  4. #4
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,421
    If you have a lot of eye candy in your forms, why not consider something other than the tired old, mundane checkbox? Could probably find checkbox images...
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    jsblume is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    20
    Quote Originally Posted by Micron View Post
    If you have a lot of eye candy in your forms, why not consider something other than the tired old, mundane checkbox? Could probably find checkbox images...
    This is not happening on a form.

  6. #6
    jsblume is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    20
    Quote Originally Posted by davegri View Post
    I think you have up to a week's option to change back to Windows 10, if you feel that's really a sufficient reason.
    That's a thought, but not a sufficient reason to switch back. Thanks for the thought!

  7. #7
    jsblume is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    20
    Quote Originally Posted by Welshgasman View Post
    Thanks! I took a look at the thread. I had wondered if it might be the Win11 theme carrying over. I'll investigate that some more.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    It's just table design view so why would this be a concern? Are you seeing blue checkboxes on forms?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    jsblume is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    20
    Quote Originally Posted by June7 View Post
    It's just table design view so why would this be a concern? Are you seeing blue checkboxes on forms?
    It is also happening on forms. It is a concern to me that it shows up in table design view because it's a visual irritant to me.

  10. #10
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,421
    This is not happening on a form.
    It is also happening on forms.
    So you've since discovered it's the style of control on the forms too? Maybe post a pic of what it looks like and you might get useful suggestions.
    That doesn't look like table design view to me - it looks like a query. Users shouldn't be playing with queries and tables as a general rule, so that leaves forms as the main issue by the sounds of it. When it comes to M$ tweaking design, it reminds me of the lines "You will be assimilated. Resistance is futile." What the Access interface looks like now seems so boring compare to the XP days. I suppose it's like minimalist art.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  11. #11
    jsblume is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    20
    Quote Originally Posted by Micron View Post
    So you've since discovered it's the style of control on the forms too? Maybe post a pic of what it looks like and you might get useful suggestions.
    That doesn't look like table design view to me - it looks like a query. Users shouldn't be playing with queries and tables as a general rule, so that leaves forms as the main issue by the sounds of it. When it comes to M$ tweaking design, it reminds me of the lines "You will be assimilated. Resistance is futile." What the Access interface looks like now seems so boring compare to the XP days. I suppose it's like minimalist art.
    Thank you, but it is an issue to me as a developer. I have a sensory processing sensitivity. When I open a table, the blue checkbox focuses my attention - it's very disruptive to my work.


    Yes, the screenshot is of a query design window. However, the effect is the same when viewing table data. Here is a redacted view.

    Click image for larger version. 

Name:	MS Access Yes-No Field in Table.jpg 
Views:	11 
Size:	165.7 KB 
ID:	46975

  12. #12
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,421
    The only thing I was able to find relates to browsers under Windows 11, and there was an option to make them plain but it was an option in the browser. All I can suggest is try a continuous form instead of a datasheet view. If it's important, you can make a continuous form look like a data sheet, assuming that helps at all. If the cf doesn't fix it, scour through Access options carefully, and look for something that might affect the checkbox rendering. Until some of us catch up with W11 and 2019 I think we're all just going to be throwing darts at it (in the dark, no less). I for one will delay moving to W11 for as long as possible.
    Last edited by Micron; 01-04-2022 at 03:21 PM. Reason: clarification
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  13. #13
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    Did you read post #3?
    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

  14. #14
    jsblume is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    20
    Quote Originally Posted by Micron View Post
    The only thing I was able to find relates to browsers under Windows 11, and there was an option to make them plain but it was an option in the browser. All I can suggest is try a continuous form instead of a datasheet view. If it's important, you can make a continuous form look like a data sheet, assuming that helps at all. If the cf doesn't fix it, scour through Access options carefully, and look for something that might affect the checkbox rendering. Until some of us catch up with W11 and 2019 I think we're all just going to be throwing darts at it (in the dark, no less). I for one will delay moving to W11 for as long as possible.
    Thank you but it is NOT an issue with form design - it's an issue when viewing data as a developer.

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

Similar Threads

  1. Query Designer with Field Value
    By dniezby in forum Queries
    Replies: 10
    Last Post: 04-10-2017, 06:09 AM
  2. Replies: 6
    Last Post: 09-12-2016, 06:52 AM
  3. Replies: 3
    Last Post: 08-04-2016, 01:01 PM
  4. Replies: 0
    Last Post: 02-03-2011, 05:40 AM
  5. Replies: 1
    Last Post: 09-19-2006, 11:07 AM

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