Ajax,
The code above dropped spaces, it should be:
Code:
IIf(IsNull([SubTaskNum]) And IsNull([SubSubTasknum]),[Task],IIf(Not IsNull([SubTaskNum]) And IsNull([SubSubTaskNum])," " & [Task]," " & [Task]))
Output:
Task
..........SubTask
....................SubSubTask
. = 1 space, this site likes to remove spaces.
Report field Rich Text - easy
Setting a single indent is easy, but there would have to be 2 types of indents, depending if it is a subtask or a subsubtask. Could HTML code be put in the query IIF code?
I'd use VBA for <p> and </p>?