Results 1 to 3 of 3
  1. #1
    bginhb is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    May 2011
    Location
    Huntington Beach, CA, USA
    Posts
    47

    Click on Locked Textbox

    I'm using a form with a sub-form. Both forms show both bound and unbound data. By disabling and locking the textboxes that the forms needs to show but the User is not permitted to change I am able to prevent the User from clicking in the box where he does not belong.



    However there is one textbox where this does not seem to work ... it is a calculated/unbound field and it like all the others has the control disabled and locked but a click on the field and the cursor remains in the box.The only difference is that this texbox uses conditional formatting.

    I there a way to manage this with properties or must I manage the conditional formatting myself?

    Appreciate any assistance.

    Bginhb

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    The conditional formatting is causing it. Did you remember to select the DISABLE button in Conditional formatting for ALL of the conditions INCLUDING the default? There is a button on there that looks like this:


  3. #3
    bginhb is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    May 2011
    Location
    Huntington Beach, CA, USA
    Posts
    47
    Thank you Bob,

    As always your answers produce excellent results.

    Merry Xmas and a Happy and Healthy New Year or Happy Holidays if you prefer.

    bginhb

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

Similar Threads

  1. Replies: 3
    Last Post: 10-16-2011, 02:51 PM
  2. On click textbox inserts value back on combobox
    By whitelockben in forum Forms
    Replies: 2
    Last Post: 10-09-2011, 05:23 AM
  3. Split From is Locked
    By DanKoz in forum Access
    Replies: 4
    Last Post: 09-02-2011, 02:07 PM
  4. I've somehow locked myself out
    By Rapunzel in forum Security
    Replies: 2
    Last Post: 07-25-2011, 02:10 PM
  5. Replies: 8
    Last Post: 05-26-2011, 09:23 AM

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