Results 1 to 8 of 8
  1. #1
    BEstes is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2016
    Location
    California
    Posts
    9

    Check box from an access form is showing as gray, instead of checked or not checked on report...

    Hello, I am about as green when it comes to Access as it gets, but in my new job, I have to track and report things in our company using an access database. What I'm currently having issues with, is a report, which, when functioning properly, draws information from an employee information form, to create employee specific job descriptions, with check boxes showing what responsibilities belong to each employee. However, it is not showing the check boxes as checked or unchecked on the report, instead, they're all grayed out. I have tried everything I can think of (which is next to nothing) to fix this, but nothing seems to work.
    Click image for larger version. 

Name:	Captu654re.PNG 
Views:	13 
Size:	577 Bytes 
ID:	24107

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Is the checkbox bound to a yes/no field in the table? Grayed out like that is when the value is Null.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    BEstes is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2016
    Location
    California
    Posts
    9
    I don't actually know. To be honest, I've been reading through a number of the posts and questions on this site, and I'm beginning to wonder if I know enough about Access to even ask questions in here.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    What is in the check box's control source property?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    BEstes is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2016
    Location
    California
    Posts
    9
    It says Main Process.

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    And the field has values in the table? Can you attach the db here?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    BEstes is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2016
    Location
    California
    Posts
    9
    I have finally figured out the issue. My predecessor changed the wording of the check box titles on the form, but not on the report. You telling me to look at the tables made me finally see what the issue was, Thanks!

  8. #8
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Glad you sorted it out, and welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 16
    Last Post: 02-05-2014, 05:50 PM
  2. Make Calculation in Report IF Check box is checked in form
    By johnjmcnaughton in forum Programming
    Replies: 1
    Last Post: 03-26-2013, 12:13 PM
  3. Replies: 1
    Last Post: 02-15-2013, 08:44 AM
  4. Replies: 2
    Last Post: 01-04-2013, 10:05 AM
  5. Replies: 22
    Last Post: 11-14-2011, 10:29 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