Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Posts
    292

    Unanswered: write protect field help

    Hi, I have a form where users enters/retrieves records.. each record is assigned a unique number ..

    when user enters data in.. on my form I have a field that shows the user the unique number for that record.. what i want to know is.. is there a way to keep the user out of that field.. I want for the user to be able to see that unique number for that record.. but i want to keep them out of it.. meaning.. no edits.. and not being able to put mouse cursor on it.. just to see that number.. greyed out if possible..

    thanks

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Text Box?

    If it is a text box>

    In design view, click the Data tab and set

    Enabled=no
    Locked=yes

    They cannot then click into the field or change the data.
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Sep 2003
    Location
    UK
    Posts
    122
    set the properties on the textbox to "Enabled: No" to gray it out or "Locked: Yes" to just block edits.

    Simple when you know how.


    you can set the Event code for on click to

    TXTsomeotherTextBox.SetFocus

    too.
    Last edited by Matt_T_hat; 09-18-03 at 11:58.
    Matt the Hat says: "what!?"
    A child of five could understand this! Fetch me a child of five!
    SCARY HARD CHALLENGE: http://www.dbforums.com/showthread.php?threadid=988682

  4. #4
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Greyed out

    Just change the background colour on the format tab to
    something like=12632256
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  5. #5
    Join Date
    Jul 2003
    Posts
    292
    Thanks to everyone.. it works !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •