Results 1 to 4 of 4
  1. #1
    HillChris7714 is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    14

    The Locked Property isn't Locking my text boxes...

    I have 2 unbound text boxes in a Form. The short of it is, they're both locked (Text Box Properties: Locked = Yes), but the user still has the ability to type characters into the boxes. Why?



    Setting them to Enabled = No doesn't allow them to type into the textboxes, but I want to be able to set the ForeColor of the text to red under certain circumstances (Me.txtMyBox.ForeColor = vbRed), and my research tells me you can't do that... that it's best to Lock them rather than Disable them.

    Does anyone know how one can make it so that an unbound, calculated field can be "locked" or "disabled," and be able to set the ForeColor in my Load event?

  2. #2
    HillChris7714 is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    14
    I fingered it out. Imma use a label instead.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I marked this thread as *Solved* for you using the *Thread Tools* at the top of the thread.
    https://www.accessforums.net/showthread.php?t=1828

  4. #4
    HillChris7714 is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    14
    I was trying to figure out how to do that... I was looking for an "Answer" button on the reply I made.

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

Similar Threads

  1. Replies: 2
    Last Post: 06-28-2014, 01:16 PM
  2. Replies: 9
    Last Post: 06-04-2014, 10:45 AM
  3. Replies: 1
    Last Post: 05-04-2014, 09:05 PM
  4. Replies: 9
    Last Post: 04-04-2014, 03:30 PM
  5. Replies: 14
    Last Post: 04-25-2013, 05:14 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