Results 1 to 8 of 8
  1. #1
    GAccess is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    38

    textbox on form is stuck on lock

    Hi All,



    I disabled my lock feature on the form. and within VBA there are no lock commands. I am wondering what else i can do to disable the locked textbox on the form.

    Please help!

    Thanks

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    I have never used this feature. Can you tell me where it is so I can try & replicate your problem?

  3. #3
    GAccess is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    38
    you can use a vba code where you use the control

    Me.TextBox.Locked = true <-- to lock
    Me.Textbox.locked = False <-- to unlock

    on the properties form control it is under the tab "Data" under the word enable

  4. #4
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Would deleting the Text Box and then putting a new one on the Form with the same [or diffenent] name be an option?
    I had a couple of experiences - not with TextBoxes, but with Output File#s once and with a Query once - when something I did during the testing process corrupted or locked [not sure what exactly Access DID but I was not able to use the objects] and the way I was able to resolve the situation was by re-creating the Query . . . and in the case of the OutputFile# [I was doing File I/O stuff] I just used a different File# (I think I was running the procedure without Error handling and the procedure had to be terminated without closing the File# . . .].

    What was the purpose of locking the TextBox?
    As opposed to . . . perhaps setting the Enabled Property to False . . . ?

  5. #5
    GAccess is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    38
    Purpose: the textbox is locked when a particular form is opened while another form is open. This particular form transfer information to the other form... hope that makes sense
    other words.. when form a is open form b gets information directly from form b.

    the textboxes should not be locked when opening form by itself. I will try what you said.. thanks

  6. #6
    GAccess is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    38
    Robeen.. making another textbox worked. I have NOOOO Idea why access was doing that.. and I spent 4 hours on it

    Thanks!

  7. #7
    GAccess is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    38
    I figured out the why.

    Within the input mask I placed: > ... access didn't like that.

    I wanted > in place for capitalization

  8. #8
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Glad it worked out! All the best!

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

Similar Threads

  1. Replies: 2
    Last Post: 03-30-2012, 08:26 AM
  2. Replies: 1
    Last Post: 07-18-2011, 03:08 AM
  3. Lock Focus on the Current Form
    By injanib in forum Forms
    Replies: 6
    Last Post: 05-29-2011, 04:22 AM
  4. Stuck on my Query by Form
    By Silver Rain 007 in forum Queries
    Replies: 0
    Last Post: 10-26-2009, 12:20 PM
  5. Can I lock out fields in a form by keying off...
    By swampdonkey in forum Access
    Replies: 2
    Last Post: 09-07-2006, 07:16 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