Mark A Matte
markamatte at hotmail.com
Tue Feb 27 13:09:12 CST 2007
Wow...Thank you very much for your gracious compliment...I wish I could take credit for the process...but I just searched for the right key words to find it. Thanks, Mark A. Matte >From: "A.D.TEJPAL" <adtp at hotmail.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Access Developers discussion and problem >solving"<accessd at databaseadvisors.com> >Subject: Re: [AccessD] Checkbox contents disappear in Word:SOLVED??? >Date: Wed, 28 Feb 2007 00:25:28 +0530 > > That is an excellent solution Mark! Much better & straightforward >than the work-around mentioned in my post. > > My best compliments. > >A.D.Tejpal >--------------- > > ----- Original Message ----- > From: Mark A Matte > To: accessd at databaseadvisors.com > Sent: Tuesday, February 27, 2007 23:38 > Subject: Re: [AccessD] Checkbox contents disappear in Word:SOLVED??? > > > I thought this should be possible...so I googled "unicode checkmark vba" >and found an example...and it actually works and displays a check mark on >.RTF > > Below are the steps and a link to the page where I found it. Good >Luck... > > Mark A. Matte > > The steps > Open the report in design view. > If you already have a check box on your report, delete it. > Add a text box for your Yes/No field. > Set these properties: > Control Source: Name of your yes/no field here. > Font Name: WingDings > Width: 0.18 in > > Type these characters into the Format property of the text box: > Hold down the Alt key, and type 0168 on the numeric keypad (the >character for False), semicolon (the separator between False and True >formats), backslash (indicating the next character is a literal), > Hold down the Alt key, and type 0254 on the numeric keypad (the >character for True), > You can now increase the Font Size, set the Fore Color or Back Color, >and so on. > > The characters > Select the characters from this list: > > Character Keypad number Description > Alt+0254 Checked box > Alt+0253 Crossed box > Alt+0252 Check mark (unboxed) > Alt+0251 Cross mark (unboxed) > Alt+0168 Empty box > > http://www.everythingaccess.com/tutorials.asp?ID=Check-boxes-in-reports > > >From: "Susan Harkins" <ssharkins at setel.com> > >Reply-To: Access Developers discussion and problem > >solving<accessd at databaseadvisors.com> > >To: "'Access Developers discussion and problem > >solving'"<accessd at databaseadvisors.com> > >Subject: Re: [AccessD] Checkbox contents disappear in Word > >Date: Tue, 27 Feb 2007 12:12:21 -0500 > > > >When I really needed it to say something besides yes and no, or 0 and >-1, I put an unbound box on the report and set the value in the Format >event of the detail section. > > > >=======The report will be published on the web, and I really wanted to >display the checkmarks, but I didn't know how to do it and retain them all >the way to the web. > > > >Susan H. >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Refi Now: Rates near 39yr lows! $430,000 Mortgage for $1,399/mo - Calculate new payment http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-17727&moid=7581