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.