checkboxes published in Word 1

[malauton]

Hi
Hope soemone can help, Im sure i read here a year or so ago about getting checkboxes to appear when publishing a report in word. If so could some one point me in the right direction or help me out
Im sure the check box was replaced by a symbol...I cannot for the life of me remember

Help
malauton

 

[Remou]

The usual thing is to use Yes or No (True / False etc):

[tt]IIf(Me.chkCheck,"Yes","No")[/tt]

 

[malauton]

Thanks Remou, Thats a way I am not familair with, I could do that by changing the checkbox to text box in the table properties, trouble is you get a whole array of yes and nos.
this makes quick scanning of the deata a bit haphazard. It would be ok if I could just have yes and omit the no's..any Ideas

malauton

 

[Remou]

The idea is to use a textbox in the report, not in the table. Set the Control Source of the textbox to reference your checkbox field, like so:

[tt]=IIf(Me.chkCheck,"Yes","")[/tt]

chkCheck should be changed to the name of the checkbox field.

The above example will not print No.

 

[malauton]

Thankx again Remou,
I tried that last night after your last post.
Access keeps putting squqre bracjkets arount the Me and returning a #Name? error

I put it in like yousaid I understand the code to be "looking at this checkbox on the current report if its true print yes if its false dont print"
but access concverts it to

=IIf([Me].[RRSClessonewee],Yes,"")

thganks for your support and time

Malauton

 

[malauton]

Remou

Got it to work!!!!

used =IIf([RRSClessonewee],"Yes","")

just prints the yes now for the checkbox true value thanks

malauton

 

[Remou]

My fault, sorry :-(
Glad you figured it out.