Prev: Can't open my Access files after conversion from Access 97 to Access 2003
Next: extract part of email after @
From: BarryL on 9 Apr 2010 22:15
I have used a query as the row source for a chart. The query generates a
number with multiple decimal places. When I edit the chart I can format the
number in the data sheet but when I save the chart and view it the number
format is lost. I can format the number in the query using a formatnumber
expression but I want to use the query as a source for another query which
calls for a number rather than text. Is there a way to make the number
formating in the chart datasheet stick?
From: Duane Hookom on 10 Apr 2010 00:27
Have you considered using a subreport rather than a chart datasheet? You
would have much greater control over the layout.

--
Duane Hookom
MS Access MVP


"BarryL" <BarryL(a)discussions.microsoft.com> wrote in message
news:F675C94D-D48E-4EE8-833C-F8EEC6E456DE(a)microsoft.com...
> I have used a query as the row source for a chart. The query generates
> a
> number with multiple decimal places. When I edit the chart I can format
> the
> number in the data sheet but when I save the chart and view it the number
> format is lost. I can format the number in the query using a formatnumber
> expression but I want to use the query as a source for another query which
> calls for a number rather than text. Is there a way to make the number
> formating in the chart datasheet stick?

 | 
Pages: 1
Prev: Can't open my Access files after conversion from Access 97 to Access 2003
Next: extract part of email after @