Simulating a Hierarchy Tree

[Marryp]

I would like to create a hierarchy tree in my report.
I will use a field called level_no to determine the placement of the field part_no. If the level_no = 1 the part_no (textbox) will be placed all the way to the left. But if the level_no = 2. I want to indent the part_no.

Please help how can I do this

 

[VogonPoet]

You can use the on_format event and some code to move the move the text box based on the value in level_no.

[ol]part_no.left = me.level_no.value * .5 * 1440[/ol]
[ol][li]You can change the .5 to however much you want to indent each level.[/li][li]In the VBA code the indent is in Twips and there are 1440 Twips/inch.[/li][/ol]

I hope this helps.

Michael

 

[Marryp]

Thanks Michael