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

The join method on a specialchars table might be another way, p'raps. But
this is certainly more direct.
On May 19, 2014 7:07 PM, "Bill Benson" <bensonforums at gmail.com> wrote:

> 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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>