Access Chart Question

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Unbound
    New Member
    • May 2008
    • 1

    Access Chart Question

    I'm using Access 2003 and am trying to figure out how to insert a field on a chart that displays the current date when opened. I have created the chart on a form that updates automatically when the data changes and would like to have the matching date displayed. Does anyone know how to do this?

    Thanks,
    Unbound
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    Originally posted by Unbound
    I'm using Access 2003 and am trying to figure out how to insert a field on a chart that displays the current date when opened. I have created the chart on a form that updates automatically when the data changes and would like to have the matching date displayed. Does anyone know how to do this?

    Thanks,
    Unbound
    The easiest way to programmaticall y display the Current Date on a Chart is to modify the Chart's Title directly, as in:
    [CODE=vb]
    Me!<Chart Name here>.ChartTitl e.Text = Format$(Now(), "dddd, mmmm dd, yyyy")[/CODE]produces
    [CODE=text]Sunday, May 25, 2008[/CODE]
    Of course, you can vary the display of the Date

    Comment

    Working...