Hello. I'm an experienced FoxPro programmer but new to Access. I have a recordset in which the first column is nLevel with values like 1, 2, ..., 6. I would like to indent each row of the report according to the value of nLevel. Say five spaces for nLevel=1, ten spaces for nLevel=2, etc.

1) How can I use the space() function to create a variable length string of blanks? I get an error when I put "=space(nlevel*5)" in the nLevel report field. I also tried "=space([nLeve]*5)" with the same result.

2) I suppose that to actually indent the row, I will need to create a single result string that contains everything in the row. Thus there would be only one column in the report definition. Is there any better way to do this?

Thanks for any suggestions.

Peter Robinson