2010 vs 2007 or 2003 very slow to render multi cell grid

[billmeye]

I have an appointment calendar that when opened determines how many time slots to show and creates a grid based on the user choices. In Access 2007 & 2003 it is lightening fast taking less than 1/2 second to load even the most complicated choices. In Access 2010 it takes 15 seconds, OUCH! The code is basically a simple loop as shown(my actual program also pulls data from various locations). Here is an example of the code:

r = 0
For y = 55 To 272 Step MyNumColumns
For x = y To (y + MyNumColumns - 1)
Me("Label" & x).Caption = ""
Me("Label" & x).Left = ((x - y) * MyColumnWidth) + MyTimeColumnWidth
Me("Label" & x).Width = MyColumnWidth
Me("Label" & x).Height = MyRowHeight
Me("Label" & x).Top = r * MyRowHeight
Me("Label" & x).Visible = True
Me("Label" & x).BorderColor = MyColorGrid
Next
r = r + 1
Next y

I have a quick sample db but I can't figure out how to attach it but I can e-mail it if anyone could help me test it out. I hope someone might be able to shed some light on what might be different.


Thank You.

 

[TheAceMan1]

How are ya billmeye . . .

[blue]Whats the point[/blue] of manipulating [blue]Label[/blue] properties as you've shown? ... This seems more like a [blue]test question[/blue] than anything else! ...

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[billmeye]

This allows the user to determine how much and what they want to view. It's an appointment screen so the user can choose the time increment, number of increments to view, how many columns to view, etc. In the end you have a spreadsheet like form with appointment information shown in the cells as needed in the caption of each label. The fewer cells shown, the bigger the font, wider the columns and taller the rows so it depends on how little or more you think you need to see in order to be happy.


I found out that my problem with the slow load may be due to the 2010 Beta and the release version does not seem to be slow so I'll have to wait until I can get a copy and find out.