UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Unable to move more than 50 labels on a report at runtime    
 
   
alancossey
post Jan 30 2010, 11:07 AM
Post #1

UtterAccess Veteran
Posts: 405
From: Norfolk, UK



I have a rather unusual application which plots results on an isometric graph. Since isometric graphs are not available directly in Access, I have to build the entire thing from scratch with lots of triangles and calculations. The way I plot data is as follows: I added 100 labels to the report in design view (programmatically, but that is by the by) and stuck them all up the top corner and made them invisible. Each label has an "o" as its caption and to plot data on the graph, I get Access to move the relevant label to the right position on the graph in the Detail_Format event. It works well, but it only moves the first 50 labels. I currently want to plot more than 50 items, but it ignores those extra ones and silently fails. No error message is generated.

Does anyone know of there being any limit on the number of controls which can be moved around at runtime?

If I can't get over this limit I shall have to programmatically draw circles instead, I suppose.
Go to the top of the page
 
+
alancossey
post Jan 30 2010, 12:22 PM
Post #2

UtterAccess Veteran
Posts: 405
From: Norfolk, UK



Ah, now I remember why I didn't want to draw circles. I need to display quite a large variety of shapes as the points being plotted and the only way I can think of to do this is to use labels with different characters on.
Go to the top of the page
 
+
alancossey
post Jan 30 2010, 01:48 PM
Post #3

UtterAccess Veteran
Posts: 405
From: Norfolk, UK



The labels actually move to the right place (checked the position and printed to Immediate Window), but they don't appear on the report.
Go to the top of the page
 
+
alancossey
post Jan 30 2010, 02:36 PM
Post #4

UtterAccess Veteran
Posts: 405
From: Norfolk, UK



Problem solved. I've used the Report.Print method to get over the problem and do away with the use of labels entirely.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 20th June 2013 - 05:25 AM