Results 1 to 7 of 7
  1. #1
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133

    Post Display Form

    Hello Everyone

    How can I change Display from to " NONE " by using Code ?


    When I click on button automatically change Display Form to " NONE "

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    Just use something like Me.MyControlName="NONE" or set default value to NONE
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    Excuse me Ridders52

    I mean change this Display Form , by using code in this below photo
    Click image for larger version. 

Name:	Capture.PNG 
Views:	10 
Size:	20.3 KB 
ID:	34127

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    Just delete the existing entry or click the down arrow and select (none) - it's at top of form list
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    yes , I know that
    but I want to change it , by using code
    when I click on special button automatically change it to None
    Are we can do it by using code ?

    I used this code : Application.SetOption "Display Form",false

    but did not succeed

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    Oh yes. sorry - didn't read your post properly
    I don't know if that's a built in property. If not, you'll have to create it
    See https://msdn.microsoft.com/en-us/VBA...-object-access

    However, is it worth doing? How often will you need to reset it?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    thanks a lot

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

Similar Threads

  1. Replies: 11
    Last Post: 07-10-2016, 10:25 PM
  2. Replies: 3
    Last Post: 01-05-2016, 12:25 PM
  3. Replies: 3
    Last Post: 10-28-2015, 12:38 PM
  4. Replies: 3
    Last Post: 03-17-2014, 10:23 AM
  5. Display info from parent form in child form
    By Leonidsg in forum Forms
    Replies: 3
    Last Post: 03-23-2013, 07: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