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

It's about to help me in an application I am updating  :-)

I'm going to put those check marks in a couple of reports in place of the current "Y"s or "X"s 

Thanks for pushing me to find the generic solution to  using Unicode characters in Access 
forms/reports.

-- 
Stuart

On 19 May 2014 at 19:06, Bill Benson 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
>