Special Character (Check Mark) in a Report

[Katef]

I am running Access 2002 for a reporting environment. In one of the reports
we need to use a check mark (Wingdings 2 [<alt>0x50]). Up until now we have
been exporting this report to Word and literally pasting all of the positives
in this report with a check mark. This is time consuming and totally
inefficient.

The report is set up to currently state ";\1;0" for the pass/fail if/then
statement. I would like it to say check mark sign and "-". Any idea how to
write this into the reporting expressions? Any assistance would be greatly
appreciated.

 

[Marshall Barton]

I am running Access 2002 for a reporting environment. In one of the reports
we need to use a check mark (Wingdings 2 [<alt>0x50]). Up until now we have
been exporting this report to Word and literally pasting all of the positives
in this report with a check mark. This is time consuming and totally
inefficient.

The report is set up to currently state ";\1;0" for the pass/fail if/then
statement. I would like it to say check mark sign and "-". Any idea how to
write this into the reporting expressions? Any assistance would be greatly
appreciated.

Change the report's text box to use the wingdings font, and
change the Format property to:

"";\<alt>0x50;\-;""

 

[Katef]

Marshall,

When I put this in below and change the font, the text box is reformatting
the "formula" to the following: >";<alt""0x50";-;

Any suggestions?

Thanks,
Kate

I am running Access 2002 for a reporting environment. In one of the reports
we need to use a check mark (Wingdings 2 [<alt>0x50]). Up until now we have

[quoted text clipped - 6 lines]

write this into the reporting expressions? Any assistance would be greatly
appreciated.

Change the report's text box to use the wingdings font, and
change the Format property to:

"";\<alt>0x50;\-;""

 

[Marshall Barton]

Yuck ;-)

It sounds like you actually typed "<alt>0x50" in there.

Now I see where I misunderstood. you were just saying the
character's hex code is 50, where I thought you were
indicating the typing sequence. The <alt> part means that
you should use the Alt key.

Instead of typing it all out, hold down the Alt key and type
0080 using the **numeric keypad** (080 is the decimal value
of 0x50).

"";\<alt>0080;\-;""
--
Marsh
MVP [MS Access]

When I put this in below and change the font, the text box is reformatting
the "formula" to the following: >";<alt""0x50";-;

I am running Access 2002 for a reporting environment. In one of the reports
we need to use a check mark (Wingdings 2 [<alt>0x50]). Up until now we have

[quoted text clipped - 6 lines]

write this into the reporting expressions? Any assistance would be greatly
appreciated.

Change the report's text box to use the wingdings font, and
change the Format property to:

"";\<alt>0x50;\-;""

 

[Katef via AccessMonster.com]

Marshall - You rock.

I don't suppose you know the value in Wingdings2 for the "-"???

Many Many Thanks!!
Kate

Yuck ;-)

It sounds like you actually typed "<alt>0x50" in there.

Now I see where I misunderstood. you were just saying the
character's hex code is 50, where I thought you were
indicating the typing sequence. The <alt> part means that
you should use the Alt key.

Instead of typing it all out, hold down the Alt key and type
0080 using the **numeric keypad** (080 is the decimal value
of 0x50).

When I put this in below and change the font, the text box is reformatting
the "formula" to the following: >";<alt""0x50";-;

[quoted text clipped - 9 lines]

 

[Marshall Barton]

Sorry, but I don't see anything resembling a dash in any of
the Wingding fonts.

 

[Katef via AccessMonster.com]

So if I can't use the "-" in wingdings, there is a "x" code 0x4F, what does
that translate to? This would be for the fail portion of the checkmark side.

With that, do you know any way to make the checkmark change color if it is
positive and that the "x" remains black?

 

[Marshall Barton]

The Format property is fairly powerful. There's a lot to it
and for all the details, you should look it up in VBA Help
and follow any links to speific data type formats.

I think you want something like:

;[GREEN]\<Alt>0080;[RED]\<Alt>0079;""