View and Print special characters

[Wiz47]

I faced a dilemma over the weekend in that I needed to preview and then print the ascii character 219 (A black block) on a report. It overlayed a paper calendar form that we use to print temporary access passes for where I work. The black blocks would indicate the days for the pass. Unfortunately, using Chr(219) did not work - so I searched the forums here and had a bit of luck, but still the solution remained elusive. Finally (and I should have done this first ) I went to Help in access and found the answer.

To view or print any special character go to the start button on the computer, then navigate to programs, then accessories, then tools, then character map. Once there, choose whatever character you want and write down the Unicode number that applies. In my case, 2588. Convert that to decimal (Because it is in Hex) to 9608 and use an SQL statement Yourfield = ChrW(9608) to view or print it. The W is added to let the program know that this is a Unicode character and not ascii.

I read a lot of ingenious solutions in the forum, but this one seems to be the most straight forward.

 

[The_Doc_Man]

Wiz, that is a great post because it is clear, relatively concise, and directly answers a common question. Thanks for taking the time to post your solution. (Which is eminently correct, by the way.)

 

[Moniker]

Note that for standard ASCII characters, you can also hold ALT and type in the ASCII code (also displayed in the aforementioned character map).

For example, ALT+0128 will produce the euro symbol (€), ALT+0169 will produce the copyright symbol (©), and so on.

You can easily make a spreadsheet of standard ASCII codes in Excel (see attached). Note that 8 is backspace, 10 is tab, 13 is carriage return, and 32 is space.

 

[Wiz47]

Wiz, that is a great post because it is clear, relatively concise, and directly answers a common question. Thanks for taking the time to post your solution. (Which is eminently correct, by the way.)

Thanks. That's one of the reasons I posted it. So a simple search would produce a pretty straightforward answer if someone was looking.

 

[Wiz47]

Note that for standard ASCII characters, you can also hold ALT and type in the ASCII code (also displayed in the aforementioned character map).

For example, ALT+0128 will produce the euro symbol (€), ALT+0169 will produce the copyright symbol (©), and so on.

You can easily make a spreadsheet of standard ASCII codes in Excel (see attached). Note that 8 is backspace, 10 is tab, 13 is carriage return, and 32 is space.

That's a good idea. I'm going to download the .zip for future reference.