printing Ω (omega) characters in report via VBA

[simon_marklar]

Hi All,

I've been bashing my head on a wall for the last two hours. I am auto generating a report and its great until i get up to displaying a label with a caption of "Ω".

you cant put the omega character into VB, it just comes out as a "?", so ctl.caption="Ω" doesnt work.

I've tried :
ctl.FontName = "Arial Greek"
ctl.Caption = Chr(217)
Debug.Print "Chr(217)=" & Chr(217)

in the debug output it prints "chr(217)=Ω", but in the report, it comes out as "Ù"

ARRRRRGGGGHHHH!!!!

can anyone sugest another way to do this. unfortunatly i have to use the omega symbol. i've already tried asking if it can be changed. they want the omega.

 

[Mile-O]

What about using the Symbol font? Character 87.

 

[dopedealer]

Simon,
I don't know what seems to be the problem, i used the symbol from your post and successfully implemented it in a table and also in a report as a caption. Maybe you could post an example database and/or further explain whats causing the problem?
Best Regards,

Chris
________
vaporizer

 

[KenHigg]

SJ suggestion works on my system...

Ken

 

[simon_marklar]

What about using the Symbol font? Character 87.

perfect!

thank you very much. I didnt even think about changing the font *slaps head*

BTW how did you get the number 87? its always been a mystery for me as charmap gives what looks like hex values (omega in symbol is char code 0x57)... do you just convert the charcode in charmap from hex to ascii ?

thanks alot!
%simon

 

[KenHigg]

Drop the 0x and use the windows calc to convert hex to dec.

 

[Mile-O]

BTW how did you get the number 87?

I switched to Excel, changed the A1 cell to Symbol, typed about until I found the Omega character, and cleared the cell of all but it. Then, in the next cell I just put =CODE(A1) which returned 87.