Results 1 to 5 of 5
  1. #1
    cotri is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Jan 2010
    Posts
    32

    Un-Check all Boxes

    I have a “Check Box” field called “PrepForShipping”. I want to set up a command button in a form view to un-check all these boxes for all my records. I need to know what script I might put for the “Event Procedure” “On Click” Thanks for any help.

  2. #2
    ansentry's Avatar
    ansentry is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2009
    Location
    Melbourne, Australia
    Posts
    67
    cotri,


    Have a look at the attached sample, it should do what you want.

  3. #3
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Have you tried...

    me.checkbox = ""

  4. #4
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    me.checkbox = ""
    or
    Me.checkbox=False
    or
    Me.checkbox=0

    all of them does the same thing. I personally prefer the second and the third.

    but for your problem the solution suggested by ansentry is apt.

  5. #5
    cotri is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Jan 2010
    Posts
    32
    That did it!! Thanks for the help.

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

Similar Threads

  1. Replies: 2
    Last Post: 05-29-2014, 09:58 PM
  2. Check box
    By nashr1928 in forum Forms
    Replies: 5
    Last Post: 04-21-2010, 02:37 PM
  3. Check boxes for seating plans
    By carlpots76 in forum Access
    Replies: 2
    Last Post: 01-16-2010, 07:35 AM
  4. Replies: 0
    Last Post: 04-19-2008, 09:08 PM
  5. check boxes
    By chiefmsb in forum Forms
    Replies: 1
    Last Post: 11-14-2006, 02:22 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