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

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