Indent and text wrap

[Thompyt]

I am using the below code set an indent in a query. This works fine until there is enough text to cause a wrap in the field on the report. How can I get the wrapped text to indent in line with the previous?

Tasks: IIf(IsNull([SubTaskNum]) And IsNull([SubSubTasknum]),[Task],IIf(Not IsNull([SubTaskNum]) And IsNull([SubSubTaskNum])," " & [Task]," " & [Task]))

If there is more elegant way, I'm all eyes.

Thanks
Wayne

[CJ_London]

you will need to use a memo field set as richtext. Then you can use the html code for indenting

[Thompyt]

Ajax,
The code above dropped spaces, it should be:

 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>?

[CJ_London]

but there would have to be 2 types of indents

not sure what you mean, I would think you have one indent or two, not a different one

not sure what the indent code is - see this link where you can construct some example text and see the codes required https://www.access-programmers.co.uk...ight=rich+text