Results 1 to 2 of 2
  1. #1
    Vita's Avatar
    Vita is offline Competent Performer
    Windows 10 Access 2002
    Join Date
    May 2022
    Location
    Massachusetts, USA
    Posts
    296

    Odd issue with Charts(new type) where the legend doesn't show text after loading the query


    I have a form that lets me choose an item from a list and it will generate a query and open a chart based on that query.
    I know the query works fine. The data shows up as bars and the query works fine on its own.
    The Chart Legend doesn't show the text for the Item even though it is set to it.
    Sometimes I can get it to show after fiddling with various options and going back and forth between design view and form view but I can't seem to tell what is causing it.

    For example earlier I had the legend text loaded for a specific Item. I closed out the chart form and pressed the button to regenerate the query and open the form and it showed the legend text!
    I thought I had fixed it so then I tried changing the item to a different item and the legend text was missing again. It's as if it is slow to load the legend text.

    I have "me.requery" and "me.refresh" at the end of the Form_Open event too but it still fails to show up.

    Any ideas why this is happening?

  2. #2
    Vita's Avatar
    Vita is offline Competent Performer
    Windows 10 Access 2002
    Join Date
    May 2022
    Location
    Massachusetts, USA
    Posts
    296
    Quote Originally Posted by Vita View Post
    I have a form that lets me choose an item from a list and it will generate a query and open a chart based on that query.
    I know the query works fine. The data shows up as bars and the query works fine on its own.
    The Chart Legend doesn't show the text for the Item even though it is set to it.
    Sometimes I can get it to show after fiddling with various options and going back and forth between design view and form view but I can't seem to tell what is causing it.

    For example earlier I had the legend text loaded for a specific Item. I closed out the chart form and pressed the button to regenerate the query and open the form and it showed the legend text!
    I thought I had fixed it so then I tried changing the item to a different item and the legend text was missing again. It's as if it is slow to load the legend text.

    I have "me.requery" and "me.refresh" at the end of the Form_Open event too but it still fails to show up.

    Any ideas why this is happening?
    This link answered my question. The 'Display Name' field was not automatically setting to the value of the item. The code the person posted fixes that issue.
    https://answers.microsoft.com/en-us/...8-647194f971f0

    If anyone has some useful vba documentation on the newer charts it would be greatly appreciated. The official documentation seems lacking.

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

Similar Threads

  1. Replies: 1
    Last Post: 02-15-2020, 12:38 PM
  2. Legend issue in MS Access19
    By AbdullahGH1 in forum Access
    Replies: 2
    Last Post: 12-09-2019, 11:37 PM
  3. Replies: 1
    Last Post: 07-02-2015, 12:49 PM
  4. Grouped Charts Issue
    By Trek9635 in forum Reports
    Replies: 8
    Last Post: 01-08-2015, 11:44 AM
  5. Replies: 3
    Last Post: 01-31-2014, 09:13 AM

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