On Format Event Code Not Working Properly Using Character Map Characters On Labels

[tdelios]

Hi All..



I have a a few labels on my report that have the visible property set to FALSE.

Within my OnFormat event, depending on what the value is within the record will trigger each one of the label's visibility to be TRUE (else FALSE).

Right now I am using the capital 'X' in the "caption" property for each one of these labels.

But I really want to use the character ▌ that I found in the character map for the caption. The problem is that the OnFormat event does not want to use this ▌ character for some reason in the report. What ends up happening is that my entire report comes out blank as if there was no character in the caption field.

So my overall 2 questions I have are:

1. How can I get the ▌ character to be visible in my report using the OnFormat code and caption property on the label?
2. are Character Map characters allowed to be used in Access?

thanks
tom

[June7]

I have copy/pasted characters from the character map (usually the degree symbol) and it prints in label or textbox control.

Exactly what character set is the ▌character from?

[ItsMe]

Have you tried typing | into the Caption property of the label via the Properties Sheet while in Design View of your Report?

[tdelios]

I have copy/pasted characters from the character map (usually the degree symbol) and it prints in label or textbox control.

Exactly what character set is the ▌character from?

It's the 'Arial' from the front character set drop down list in the character map..

[June7]

I have no problem printing that character in label (but not in textbox). Cannot replicate issue.

Did not test with code to set visibility. Don't think that should make difference. Suggest you test this character in a label set to always display.