Bullet list in text box (Access 2000) 1

[CarpalT]

In access 2000, I am trying to create a form letter with a bullet list:
=Chr(149) & " Fact one" & Chr(10) & Chr(149) & "Fact two"

The first chr(149) produces a bullet nicely, but the Chr(10) does not do a line feed. Instead it prints a little box.

I also tried chr(13) carriage return, and chr(12), which I saw somewhere in a faq.

Am I trying to do something that Access won't do? I know I could put each fact in its own text box.
Thanks in advance for any help!

The world is full of good people.

 

[dhookom]

Try
=Chr(149) & " Fact one" & Chr(13) & Chr(10) & Chr(149) & "Fact two"

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CarpalT]

Thanks dhookom, that works like a champ! Have a star!


The world is full of good people.