[AccessD] Access 2000 Charts

Joe,

    The problem faced by you indicates that the desired values of RowSource have not yet sunk in. What you are seeing, are the default values. As a remedial action, direct editing of source datasheet for the chart object has to be undertaken.

    My sample database named ChartsDemo might be of interest to you. It is available at Rogers Access Library (other developers library). Link - http://www.rogersaccesslibrary.com 

    This db demonstrates handling of charts on forms as well as reports. Items 1 & 6 of the tips provided therein should be of special relevance to your case.

Best wishes,
A.D.Tejpal
--------------

  ----- Original Message ----- 
  From: Joe Rojas 
  To: 'Access Developers discussion and problem solving' 
  Sent: Thursday, August 11, 2005 01:25
  Subject: [AccessD] Access 2000 Charts


  Hi all,

  I have two problems that are driving me crazy with the charting control that Access 2000 uses.

  1) When I had a chart using the wizard, the datasheet for the chart is using the East, West, North data that is there by default despite the fact that my Row Source is correct. Is there a way to have the control update to reflect "real" data?

  2) I resized my chart so that it fills up most of the area on my report and then changed the size mode to zoom. When I do this the text is monstrous despite the fact that the font size is set to 8. Is there a way to have the chart use the font size that is  specified?

  Thanks!
  JR