Results 1 to 2 of 2
  1. #1
    MrDummy is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    50

    Text box inactive based on value in another field

    Hello,



    I have a simple question but answer seems hard to find.

    I have a form where information is filled in.

    Is it possible that text box 2 becomes inactive (meaning no info can be entered) when in text box 1 info is entered that does not require text box 2 to be filled in or if a Yes/No field is completed as No.

    In short: the text box 2 should be inactive or active based on the value (criteria) that is filled in textbox 1.

    for example: if value in textbox is "1" then textbox 2 to become active and info can be entered in textbox 2. if value in textbox 1 is "2" then textbox 2 to become inactive and no info can be entered.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You may get some ideas from the information here.

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

Similar Threads

  1. Replies: 3
    Last Post: 02-28-2015, 06:52 PM
  2. Replies: 1
    Last Post: 03-27-2014, 06:42 AM
  3. Replies: 3
    Last Post: 06-12-2013, 08:53 PM
  4. Inactive Field
    By Dee300 in forum Access
    Replies: 4
    Last Post: 03-03-2011, 12:18 PM
  5. Replies: 2
    Last Post: 05-05-2010, 02:52 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