Simple Question (I hope)

  • Thread starter Thread starter RC-
  • Start date Start date
R

RC-

I have a report header that needs (doesn't really need it, but I would like
to have it) an ampersand in the name. I.E. Company Listing & Directory.
When I add it, it turns the "&" into an underscore "_" and the "&" doesn't
show up even when the report is ran. Is there anyway around this?

TIA
RC-
 
RC- said:
I have a report header that needs (doesn't really need it, but I would like
to have it) an ampersand in the name. I.E. Company Listing & Directory.
When I add it, it turns the "&" into an underscore "_" and the "&" doesn't
show up even when the report is ran. Is there anyway around this?
Click to expand...

Use 2 ampersands in a row.
 
I think the fix is to type the ampersand symbol twice in
your header string "Company Listing && Directory"
HTH
 
additional note...
the reason this works (and is required) is because the
ampersand symbol has special function in Access. In order
to get the symbol itself to appear in text is to type it
twice in the string.
hcj
 
Yeah, I know is used to concatenate two strings together. I had a feeling
it would be a simple fix. Thanks for the extra info though!

RC-
 
You can use Visual Basic to put the text into the report,
using the ASCII character for the ampersand
 
Back
Top