Indented Text Box Values on Forms?

  • Thread starter Thread starter David Altemir
  • Start date Start date
D

David Altemir

I have a continuous form that I want to use to display an indented
list. I want the list to be displayed in the form like:

Value1
Value2
Value3
Value4
Value5
Value6
Value7
Value8

These values are stored in a table with the level of indenture in one
of the columns. i.e.:

0 Value1
0 Value2
1 Value3
0 Value4
1 Value5
2 Value6
2 Value7
0 Value8

How can I use the level of indenture number in a text box formating
statement to display the values I want to see them? I'm thinking
along the lines of:

=[IndentLevel]*" " & [MyValue]

where I insert a series of spaces in front of the value so that it is
effectively indented.
 
Back
Top