Can indents/tabs be changed dynamically?

[gellerche]

I have a report that has a query as its datasource. The query has a numeric field (Indents) and some text fields. What I would like is for the text fields in my report to be indented, or have the Tab key pressed, depending on the number in the Indents field. The indenting would only happen once per row, starting on the left. For example:

Indents TextField1 TextField2
1 text1 text2
3 text3 text4

would look like

.....text1 text2
...............text3 text4

(the . are the only way I could indent. In the report, I would like them to be blank spaces). If someone knows how to do this, I would appreciate your help.

Thank you,

Steve Geller

 

[Rich]

Not sure I fully understand but look up the LPad and RPad

 

[gellerche]

I solved it this way: I used a query to get the data for the report. Then I put the spaces I wanted by combining the fields I wanted into one large string, and putting spaces before them, like this:

IndentedLevelName: Space(5*[tblStructureIndents]!

)+[tblStructure]![Text1]+Space(5)+[tblStructure]![Text2]

Then I put 'IndentedLevelName' on my report, and it was indented just fine.​