Hi Andrew,
Luckily, You found a work-around. Captions (labels and buttons) in Access accept Unicode characters in the design environment and will display them in the runtime. However, the programmatic interface to them seems to just give 8-bit, chr$() and ASC() compatible string access.
This is not 100% true.
You can use ChrW() and AscW() to add Unicode (extended) characters to a caption on a button or label.
Me.lblHeader1.Caption = Me.lblHeader1.Tag + ChrW(&H25BC)
Will add a down arrowhead
Me.lblHeader1.Caption = Me.lblHeader1.Tag + ChrW(&H25B2)
will add an up arrowhead.
There's always more than one way to skin a cat ;-)
--- In MS_Access_Professionals@yahoogroups.com, adwsys <no_reply@...> wrote:
>
> Hi All,
>
> Does anyone know of a way of including extended ASCII characters in a form label in Access?
>
> I have a continuous form in which some of the column heading labels can be clicked to sort the records in the form by that column. What I want to do is when the user clicks on a label to sort the records, I want to change the label caption so that it contains an indicator that the form is sorted by that column. I'd thought of simply using the extended ASCII triangle characters (▲ & ▼) but I can't find a way of reproducing them on the label using VBA.
>
> Andrew
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar