Results 1 to 4 of 4

Prohibit manual entry in a formula based textbox

  1. #1
    pgruenke is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2018
    Posts
    9

    Prohibit manual entry in a formula based textbox

    I have a form with several textboxes that are the result of either adding, or the contents of other text boxes. I don't want the users to be able to edit these text boxes. I made them unbound with the other textboxes being the data source, and wrote a macro to save the contents of the textbox to the table prior to update. However, the data isn't being saved. Help would be greatly appreciated.

  2. #2
    Peter M is offline Advanced Beginner
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2017
    Posts
    65
    1) How/where are you saving the contents if the control is unbound?
    2) If you are using a macro to save the contents prior to update, it might be more reliable to recalculate the end result inside the macro (as well as on the form). There is a possibility that the code executing "prior update" is considering the custom unbound text box to be empty.

  3. #3
    pgruenke is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2018
    Posts
    9
    Peter, it was a duh moment. I realized that all I had to do was lock the field so that it couldn't be manually updated. I assumed that locked meant locked and nothing could be entered.

  4. #4
    Peter M is offline Advanced Beginner
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2017
    Posts
    65
    Ah - no worries. I've done the same thing many times. I always get 'Locked' and 'Enabled' mixed up when I want the user to be able to copy & paste the data but not change it.

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

Similar Threads

  1. Replies: 25
    Last Post: 01-29-2017, 04:59 AM
  2. Formula in a textbox
    By cfobare79 in forum Access
    Replies: 1
    Last Post: 01-28-2015, 10:07 AM
  3. Update Query for manual entry
    By armyofdux in forum Access
    Replies: 6
    Last Post: 11-24-2014, 05:36 PM
  4. Manual Primary Key Entry
    By harpreett.singhh@gmail.co in forum Access
    Replies: 1
    Last Post: 03-03-2014, 03:09 PM
  5. Updating record based on textbox entry
    By timmy in forum Programming
    Replies: 16
    Last Post: 04-06-2011, 12:05 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
  •  
Tech Forums: Microsoft Office Forums