underscore replaces & in text field

[C. Hoekstra]

When using the &-sign in a text field, Access replaces
this with an underscore. I want a text field displaying
'A & A', which is the name of our department. On the form
this changes into 'A _A'.
Is there anyway around this?

C. Hoekstra

 

[Glenn]

Are you sure it's a text field ? If the database entry is
A & A this is what should appear.

If on the other hand you are using a Label field then the
caption should be entered as "A && A", which will show as
A & A.

Rgds,
Glenn.

 

[John]

Yes you need to type A && A
John