Results 1 to 4 of 4
  1. #1
    gpeirce is offline Novice
    Windows 8 Access 2007
    Join Date
    Oct 2015
    Location
    Oregon, USA
    Posts
    13

    Preventing operator from clicking an unbound box.

    I've developed a "dashboard" form that displays all kinds of demographics in text boxes. The text boxes are filled in by multiple queries running when the form is current.



    This form is not used for any input or updating, it's solely for display statistics.

    How can I get the fields to be protected so that the user can't even click the field? I have it locked, but values like 3.33 show up as 3.33333333333 after the click.

    Any ideas?

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,928
    set both lock and disable properties to true

  3. #3
    gpeirce is offline Novice
    Windows 8 Access 2007
    Join Date
    Oct 2015
    Location
    Oregon, USA
    Posts
    13
    Brilliant!!!! Now where is the "thank you" button in this forum now?

  4. #4
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,928
    Just click on the star to the left at the bottom of the post

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

Similar Threads

  1. Replies: 2
    Last Post: 09-15-2015, 03:08 AM
  2. Replies: 9
    Last Post: 11-06-2014, 01:15 PM
  3. Preventing Auto New Record
    By The Professor in forum Forms
    Replies: 6
    Last Post: 02-08-2013, 01:17 PM
  4. Preventing a Null error
    By tylerg11 in forum Forms
    Replies: 15
    Last Post: 06-23-2012, 11:18 PM
  5. Preventing multiple checkboxes
    By emerywang in forum Forms
    Replies: 2
    Last Post: 01-26-2010, 01:43 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