Alt Codes

[FL_Boy]

Is there anyway to display these or similar extended Alt Codes using a native CHR or similar function?
Ideally I'd like to have a Combobox and have the user select one of about 10 of these icons in lieu of a text selection.

Here's a link to the symbols.



https://altcodeunicode.com/alt-codes...sport-symbols/

[Micron]

CHRW(####) ?

e.g. CHRW(9788) will put a sun into a table text field. 9788 is the long integer version of the hexadecimal value if I'm not mistaken.
I don't know if a combo, textbox or any other control will support unicode - never tried.

[moke123]

I just entered Alt code in a table text field and it does display in both the table and a combobox.
How it works from there you'll have to experiment.

[davegri]

My experiments:




Loaded the images in the textboxes to the value list of the combobox.
You could make the textboxes not visible.
Not sure how you would deal with the combobox after_update event to actually use the setup.

Option Compare Database
Option Explicit


Private Sub Form_Load()
    Me.cboList.AddItem Chr$(34) & Me.t1 & Chr$(34) & ";"
    Me.cboList.AddItem Chr$(34) & Me.t2 & Chr$(34) & ";"
    Me.cboList.AddItem Chr$(34) & Me.t3 & Chr$(34) & ";"
    Me.cboList.AddItem Chr$(34) & Me.t4 & Chr$(34) & ";"
    Me.cboList.AddItem Chr$(34) & Me.t5 & Chr$(34) & ";"
    Me.cboList.AddItem Chr$(34) & Me.t6 & Chr$(34) & ";"
End Sub

[Micron]

Ja, but as you well know, we shouldn't be editing directly in tables
Besides, I found that when you do that, some characters look like symbols shown at the link while some look like Cyrillic characters but if you use ChrW they are stored as shown at the link. I suspect that's because some Unicode values will be stored as they should be, while others need to be stored as hex values. Not sure if that's because the function converts Alt+values to hex and all hex is properly represented, or if it's something else.

EDIT -I think if you use the function you can still bind controls rather than using calculated ones that cannot be bound. In my limited testing a form shows the proper unicode characters as long as I use ChrW in an update query.

[moke123]

I tried a message box and some of the symbols didn't display correctly

[Micron]

I doubt you can show glyphs in a textbox because it only accepts string. That's my 2¢ anyway.

That's alt+155 BTW.