Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    1

    Hiding and Displaying fields based on value of another field

    Is there an easy way to do this in Access? I'm new to using the program and I'm familiar with Lotus Notes and Lotus Domino.



    I have a variety of fields in my database. For example, there are 10 that should only appear visible to the end user if the value of the field called "type" is set to "enhanced". How would I go about accomplishing this?

    Any help would be much appreciated.

    thank you much,

    Dan

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109

    For what's its worth...

    In the 'Property' of the Form, select the 'Event' tab and go to 'On Current'. Select '[Event Procedure]' in the dropdown and click on the ellipses to the right '...' and add code something like this.

    If Me.type = "enhanced" Then
    fieldname.Visible = True
    Else
    fieldname.Visible = False
    End If

    You may also want to add this same code on your 'type' event under 'After Update'. Obviously, replace 'fieldname' with the name of your field. Without knowing how your form is designed, you may need to play around with it.

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

Similar Threads

  1. form not displaying fields
    By ashiers in forum Forms
    Replies: 0
    Last Post: 09-19-2008, 07:02 AM
  2. Replies: 1
    Last Post: 08-04-2008, 03:30 AM
  3. Replies: 0
    Last Post: 04-17-2008, 09:24 AM
  4. Form field not displaying in query
    By Valeda in forum Queries
    Replies: 2
    Last Post: 05-05-2006, 10:08 AM
  5. Concatenate two fields (text & number) for key field
    By Larry Elfenbein in forum Forms
    Replies: 2
    Last Post: 11-10-2005, 07:45 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