From: Bernard on 17 Apr 2010 17:00 I am using Access 2003 SP3 in Win Xp. I am trying to produce a pie chart with Data Labels having 1. Regions, 2. Value, 3. %. Everything is fine in Design View, the value shown as £1,234 (as formated)but in the report the Value is displayed as 1234.5678 ie not formated and no £ sign. I have formated everywhere I can find, including the underlying query and data sheet. Surely it must be possible to format the value in currency? If I format Value as a number with O decimal points, again it works perfectly in design view but not in the report. -- Bernard
|
Pages: 1 Prev: show total in each page , How Next: Problem with repeating values in report |