[AccessD] The most obscure question - alt coded symbol in a query result (check mark)?

Neat, can't wait to try this. I hope it helps someone else display check
marks in a yes/no field someday!
On May 19, 2014 7:03 PM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote:

> ChrW() is used for a Unicode characters, not CHR().
>
> A  little bit of copy/paste together with the AscW() function gave me the
> answer :-)
>
>  IIf([Completed],ChrW(8730),Null)
>
> --
> Stuart
>
>
> On 19 May 2014 at 17:51, Bill Benson wrote:
>
> > I am not making this clear enough. I have a yes/no field called
> > Completed. I *want* it to stay yes no. I am already doing what you
> > suggest which is to change the field type to Short Text and store the
> >  instead of a T/F value. But that is not what I want to do.
> >
> > If there was a way to get ALT 251 in the output of a query from the
> > SQL itself, that would have been good. Suppose there were a function
> > called MYALT in Access instead of CHR... which doesn't work because
> > CHR(251) is not a  in standard character font. I would have changed
> > my rowsource to
> >  Select MyItem, IIF([Completed],MYALT(251),"") as IsCompleted
> >
> > I have another approach now, I can keep the characters I want as a
> > lookup table in a SpecialCharsTable. I might have a problem with the
> > field type if I want to use this for more than Booleans, but I will
> > worry about that bridge when I get to it.
> >
> >  OrigValue    NewValue
> >  ------------ ------------
> >  True
> >  False                NULL
> >
> > New list rowsource:
> >  Select E.MyItem, S.Char as IsCompleted
> >  From Events as E INNER JOIN SpecialCharsTable as S
> >  ON E.Completed = S.OrigValue
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David
> > McAfee Sent: Monday, May 19, 2014 5:26 PM To: Access Developers
> > discussion and problem solving Subject: Re: [AccessD] The most obscure
> > question - alt coded symbol in a query result (check mark)?
> >
> > I was able to copy and paste the checkmark from your original message.
> >
> > I pasted it into one of my Access tables and it shows.
> > I changed the font on the table and it still shows in the table as
> >
> > I created a query and it shows as
> > So I assume you can read it into a variable and use it as needed.
> >
> > D
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>