Results 1 to 2 of 2
  1. #1
    Ira is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Location
    South Florida
    Posts
    29

    Changed Menu Label in Ribbon

    I have menu drop down in the ribbon that filters records. Initially it looks like "Filter: Active". After the user selects a new choice from the drop down, I would to change the Label to "Filter: Inactive". I know how to use invalidate to change a control on a ribbon, but can't seem to find the way to change the label on a menu. GetLabel does not work.

  2. #2
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    India
    Posts
    616
    You will need a flag to determine if filter is active, like a public variable say FilterActive.
    Set it to True initially. Change it to False after user selects a new choice.
    The value of this variable will determine the caption in GetLabel function.
    If FilterActive=True caption is "Filter: Active" else "Filter: Inactive"

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

Similar Threads

  1. New Ribbon with drop down menu
    By gstylianou in forum Access
    Replies: 3
    Last Post: 06-03-2014, 01:31 AM
  2. Replies: 1
    Last Post: 04-25-2014, 11:41 AM
  3. Replies: 1
    Last Post: 01-02-2014, 05:51 AM
  4. Replies: 0
    Last Post: 09-25-2012, 09:16 AM
  5. Replies: 7
    Last Post: 05-29-2009, 04:27 PM

Tags for this Thread

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