Special Characters in VBA (1 Viewer)

[Teggun]

Hi guys, I'm having a problem when inserting a specific special character in a VBA code. I need this character (Ω) to show up together with a string after certain action happens, but Access does not let me paste it in the string field, it shows "Ù" instead.

I've tried to create a query with this specific character but does not recognise it. Also not working when using Chr(937), which is his ASCII code.

Is there any way to call this character? I can use it in labels and text boxes in some of the forms I have so I assume it does exist inside of Access.

Thanks for your time.

 

[arnelgp]

set the Font Name of your label/textbox to Symbol.
you can now insert that symbol on your label/textbox.

 

[June7]

Chr(937) errors in VBA immediate window and textbox. Any number over 255 errors.

ChrW(937) does not error but doesn't display the Omega character in VBA immediate window, does in textbox. Review https://www.mrexcel.com/forum/excel-questions/522172-vba-macro-find-replace-omega-ohm-symbol.html

 

[Teggun]

Thanks for your answers, indeed that was exacly what I was looking for, didn't know it existed such a function to call this specific symbols.