Replies

Jerry,

not really suitable for all cases – I need to have both controls displaying, e.g. the positioning of lines and graphics is quite tight. The posting by Charlotte suggesting use of the DoCmd.RunCommand acCmdBringToFront looks to be a working solution.

Charlotte,

yeap it’s starting to look like a wizard – I’d not planned it to be a fully comprehensive wizard, rather a simple tool for me to use in report generation, but other people have seen it, and …. it’s growing

Thanks for the tip on the acCmdBringToFront / acCmdSendToBack – I’m now driving the order of creation by a sequence flag in the data table, but it’ll be useful to have a way to adjust after the order after creating a report

Cheers,
Steve C.

Jerry,

the problem is how to do this using VBA – I can do it manually in the Report Design view, but what I’m trying to do is emulate this process in code. I can’t find any reference to a property which sets the ‘depth’ of the control, I assume it’s implicit to the order in the Controls collection, but I again can’t find a way to re-order the collection.

Charlotte,

I think no, but the creation of controls on reports is new to me, so …
What I’m trying to do is reorder certain controls so they are on top of others, e.g. I have some graphic lines that I want to be on top of an image. I’m creating the report controls from data in a table, so I’ve added an order flag, but the how-to do in VBA the same as the menu operation “Bring To Front” is still bugging me.

Cheers,
Steve C.