By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 2,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Access Chart Question

P: 1
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
May 25 '08 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,597
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 programmatically display the Current Date on a Chart is to modify the Chart's Title directly, as in:
Expand|Select|Wrap|Line Numbers
  1. Me!<Chart Name here>.ChartTitle.Text = Format$(Now(), "dddd, mmmm dd, yyyy")
produces
Expand|Select|Wrap|Line Numbers
  1. Sunday, May 25, 2008
Of course, you can vary the display of the Date
May 25 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.