Graph Object: Forcing .DataSheet column's numeric format?

[PeteCresswell]

The following code is working for everything but the column formatting
on lines 9191 and 9192. It doesn't trap out - just doesn't "take".

"fChart" is a pointer to the open form that has the Chart object on it.
--------------------------------------------------------------
Dim myChart As Graph.Chart
9110 Set myChart = fChart!gphStats.Object.Application.Chart
9111 With myChart
9112 .HasTitle = True
9113 .ChartTitle.Text = myTitle
9114 .ChartTitle.Font.Size = 8
9119 .ChartTitle.Font.Bold = False

9120 .HasLegend = False
9129 .ChartType = xlLine

9170 .Axes(xlValue).HasTitle = False
9171 .Axes(xlValue).TickLabels.NumberFormat = "#0.000"
9172 .Axes(xlValue).TickLabels.Font.Bold = False
9179 .Axes(xlValue).TickLabels.Font.Size = 8

9180 .Axes(xlCategory).HasTitle = False
9181 .Axes(xlCategory).TickLabels.NumberFormat = "mm-yy"
9182 .Axes(xlCategory).TickLabels.Font.Name = "Arial" '"Microsoft
Sans Serif"
9183 .Axes(xlCategory).TickLabels.Font.Size = 8
9184 .Axes(xlCategory).TickLabels.Font.Bold = False
9185 .Axes(xlCategory).TickLabels.Orientation =
xlTickLabelOrientationUpward
9189 .Axes(xlCategory).MinorTickMark = xlTickMarkInside

9191 .Application.DataSheet.Columns(1).NumberFormat = "mm-yy"
9192 .Application.DataSheet.Columns(2).NumberFormat = "0.000000"
9199 End With
--------------------------------------------------------------

I'm starting to wonder if I'm trying to fool Mother Nature by going
after the .DataSheet props directly.

Could it be that there are some props on the Chart itself that I could
set to acheive the same end?

[Tim Marshall]

PeteCresswell wrote:

Could it be that there are some props on the Chart itself that I could
set to acheive the same end?

Pete, I don't have any direct answer for you, but something I found very
useful about 6 years ago when I was doing chart automation in Access was
to first do it in Excel. If there was a specific property I wished to
change, I'd set up a graph in Excel and then record a macro. Then I'd
change the property I wanted, stop the macro and then look at the VBA.

Most times, this gave me the properties I was looking for to change in
A97 VBA. There were the occasional things that did not seem to have a
corresponding property or, more likely, I was unable to find it in
Access VBA, but this approach worked beautifully.

My apologies if you're doing this already and for not directly answering
your question.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me