Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
Sep 03, 2022
Solved

Modern Chart - adding Dynamic Chart Subtitle?

Hello Experts,    I have done some research on this topic and I have not been able to find a way to  add a dynamic chart title.  I have to manually copy and paste my text to the chart's subtitle fi...
access
Chart
  • isladogs's avatar
    isladogs
    Sep 03, 2022
    Yes - use DLookup
    Me.Chart0.ChartSubtitle = DLookup("FieldName", "Table/QueryName", "FilterCriteria")

    e.g.
    Me.Chart0.ChartSubtitle = DLookup("MyDateTime2", "t_Graphdata", "MyDataID = 4456")
isladogs's avatar
isladogs
MVP
Sep 03, 2022
Yes - use DLookup
Me.Chart0.ChartSubtitle = DLookup("FieldName", "Table/QueryName", "FilterCriteria")

e.g.
Me.Chart0.ChartSubtitle = DLookup("MyDateTime2", "t_Graphdata", "MyDataID = 4456")
Tony2021's avatar
Tony2021
Iron Contributor
Sep 04, 2022
Perfect. Exactly what I was looking for.

thank you.
  • isladogs's avatar
    isladogs
    MVP
    Sep 04, 2022
    That's great. Glad I could help.
    Personally, I rarely use modern charts as I find them much more limited in terms of what you can do with them compared to the older 'classic' charts.

    You might be interested in the video of Crystal Long's presentation on Classic vs Modern charts to the AccessEurope User Group in May 2022.
    See https://www.youtube.com/watch?v=iTryE5nUSC8

Resources