Problem with '&&' on report

[Douglas Sanders]

I have a report that is emailed out as an acknowledgment. It contains a
pair of '&&' in the company name as in 'Johnson && Johnson'. It displays
fine in Access ('97) as 'Johnson & Johnson' but the emailed report shows the
double ampersand in the word document.

Is there a fix for this?

Thanks,
Doug

 

[Rick B]

If sent in snapshot format, you will see exactly what is on the screen in
Access. Other than that, I don't know of a way.

Rick B

 

[Douglas Sanders]

I was able to fix the problem.

Instead of using a Label box, I used a Text box. I threw away the label
portion and entered the data I wanted as the Control Source as ="Johnson &
Johnson"

Displays fine in both Access and the email.

Doug