Checkboxes in report

[hrinterndcarc]

I have created a database in which there is a form with several checkboxes the user can click (the checkboxes stand for locations in which people are on call for, and they are clicked "Yes" if they are available to work there, and "no" if they aren't.)

In the report I have created there are columns for their name, and all 15 locations. Under each location column there are checkboxes that are either checked or unchecked. I was wondering how I go about hiding the checkboxes in the report for the locations that are unchecked. I understand that there is some kind of code I must write in order to made these unchecked boxes invisible. I am very new to this program and I am unsure where I would write this code and what I should be writing. I have seen code similar to

If CheckBox1 = False Then

CheckBox1.Visible = False

End If

but I have no idea if this works and where I would put this code.
Any help would be greatly appreciated.

Chris

 

[KenHigg]

Look at this: http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=12151&d=1136824685

See the query behind the report...

 

[hrinterndcarc]

I'm sorry but that file won't open for me, it tells me that my Access program needs to be updated. I am currently using Access 2000 here at my internship. Im unsure what to do about this now.

 

[KenHigg]

I think a 97 ver is avail here:

http://www.access-programmers.co.uk/forums/showthread.php?t=99777

 

[hrinterndcarc]

Thank you, I'll see what I can figure out. I appreciate this.

 

[hrinterndcarc]

Ok, I've been looking at it that db and I'm trying to understand the query, basically what your db does is that when the checkbox is checked yes, the word yes appears in the next column and vice versa for "no". I'm not completely familiar with the

MyNewFld: IIf([blnYesNo],"Yes","No")

and what I'm trying to do is just make the actual box that appears on my report invisible if it is unchecked. On the actual report that prints there are checkboxes under each column that are either checked or unchecked. I would only like the ones checked to be visible. I'm sorry that I can't figure this out from what you sent yet.

 

[KenHigg]

I think you would simply use that check box test as a criteria in the reports underlying query to filter out the records where the check box is not selected.. (Or am I missing something?)