get the symbol Ø chr(157) (1 Viewer)

[chemil]

Hello,
I want to create a custom shortcut right click menu.
The problem I cannot seem to get the symbol Ø with chr(157) function.
All chars from 0 to 127 no problem. The sign should be appear at the menu beside other Signs like %,<,>,=….. (no problem to use them)
This sign is used as a diameter at drawing
Many thanks
ch

 

[apr pillai]

Type the following expression in the VBA Debug Window (Immediate window) directly and press enter key to list out the active keyboard code and it's corresponding character:

for j=123 to 255:print j,chr(j):next

This will display the character codes. Check for the character and the corresponding code you want to print.

On my machine the Code 216 gives the above character.

 

[chemil]

Unfortunately, the appearance of the symbol related to VBA editor font'
My font is in foreign language. Therefore I cannot use chr (216) the sign like - > "
There is another option to set the Ø sign? In the foreign language there is no such sign- Ø?
thanks
ch

 

[apr pillai]

Try this:

1. Open a new MS-Word Document.
2. Select More Symbols... from the Symbols button from Insert Menu.
3. Select the required Font in the Fonts control.
4. Move the Vertical Scroll-bar and find the symbol you want.
5. Double-Click on it to insert the symbol on the document.
6. Copy the symbol and paste it into Access where you want it.

It worked for me to insert it into an expression in a text box.
Image Attached.

 

[chemil]

Thank for reply!
But, when I paste the string on my VBA editor which defined with foreign language
Fonts, I get this--> cmbControl.Caption = "=?%<=>?"
After that the shortcut menu caption is not ok, without Ø sign.
I do not have many options because my GUI is in foreign language to
Any way, if you have solution for this issue I will be happy to hear.
Thanks in advance
CH