Special characters in Form Header caption

[RenaG]

I am using Access 2007.

I would like to put an '&' in the Form Header of my subform. Something like this:
Fundraising & Offsetting Revenue

But I keep getting this error:

This label might not be using the '&' character correctly.

I have tried double quotes around it, single quotes around it and preceding it with a '\' and nothing works. Is there a way I can use an '&' in this heading?

TIA,
~RLG

 

[shadow9449]

Rena:

Try using && (i.e double ampersands)

SHADOW

 

[missinglinq]

A single Ampersand (&) tells Access to put an Underline character under the next character, making it the character to use with <Alt> as a Shortcut. To use an Ampersand as a literal character, as you're trying to do, you need to use two of them:

Fundraising && Offsetting Revenue

will display as

Fundraising & Offsetting Revenue

Linq ;0)>

 

[RenaG]

Thank you both! The double ampersand works (of course!). And yes, I was seeing the underscore in place of the '&' when I was just using one.

Thanks!!
~RLG

 

[shadow9449]

Most welcome...glad we could help!

Good luck

SHADOW