Results 1 to 2 of 2
  1. #1
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618

    Form. VBA code to be visible or not

    I have a form f02Diary. I need code in vba to do the following. If in text field T003 =26, then Text fields T005 and T006 should not be visible after update. Thank you.

  2. #2
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    You can use this Code :
    Click image for larger version. 

Name:	Capture.JPG 
Views:	13 
Size:	34.5 KB 
ID:	32046
    Click image for larger version. 

Name:	Capture1.JPG 
Views:	14 
Size:	33.0 KB 
ID:	32047
    If (me.T003) = 26 then
    me.T005.Visible=False
    me.T006.Visible=False
    ElseIf (me.T003)<>26 then
    me.T005.Visible=True
    me.T006.Visible=True
    End If

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

Similar Threads

  1. Replies: 16
    Last Post: 03-26-2015, 08:35 PM
  2. Make form visible from VBA code
    By GraeagleBill in forum Programming
    Replies: 6
    Last Post: 12-16-2014, 04:19 PM
  3. Replies: 4
    Last Post: 11-04-2014, 07:35 PM
  4. Switchboard code not visible
    By rahulmudiraj in forum Access
    Replies: 7
    Last Post: 12-12-2012, 04:57 PM
  5. Replies: 2
    Last Post: 01-06-2011, 04:38 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