bullet points

[cbrsix]

I have a report that contains bullet points of things included that the client has signed. Every bullet point is not used each time so I wrote an IIF function to determine when to include the other bullet points. Now my problem is that I want the other bullets to line up under each other. I can't figure out how to do this. When I do it, they just line up in sentence form. Any suggestions?



Here is a copy of what I'm talking about..

• As well as any additional documents you may havsigned." & IIf([Account List.Product Type]="Advisory","• Completed Discretionary Investment Management Agreement.",IIf([Account List.Product Type]="Mutual Fund" Or [Account List.Product Type]="529","• A copy of the Prospectus Receipt and Disclosure Form.",IIf([Account List.Product Type]="Variable Annuity" Or [Account List.Product Type]="Variable Life" Or [Account List.Product Type]="Fixed Annuity" Or [Account List.Product Type]="Equity Index Annuity","• A copy of the Prospectus Receipt and Disclosure Form• A copy of the completed Variable Contract Suitability Form.","")))

[June7]

You need to force a carriage return line feed. Use Chr(13) and Chr(10).
• As well as any additional documents you may havsigned." & Chr(13) & Chr(10) & IIf(...

The last IIf has two bullets:
"• A copy of the Prospectus Receipt and Disclosure Form" & Chr(13) & Chr(10) & "• A copy of the completed Variable Contract Suitability Form"

[cbrsix]

Thanks. That worked perfectly.