How to set check boxes in "Detail" section of a report 1

[bnath001]

Hi,

I have an MS access report and in the detail section of the report, I need to have a check box control.

and it should be checked.

How can I do that.

thank you
nath

 

[smoker1]

Is the check box related to a table field with the data type set to "yes/no"? If so, it will automatically check if the field is "yes", and it will stay un-checked if the field is "no".


Angela

 

[bnath001]

the Check box is not related to any data field in the underlying table/query. I have put a check box in the detail section and I need to write piece of code to check them when the report is run.

thank you
nath

 

[WillYum]

I'm not a Access Expert I would recommend using a graphic instead of trying to code a "checked box" - Simply screen capture a window with a checked check box and then crop that image down till it is just the box and then insert it.

That would be my suggestion, for sheer simplicity.

- William - William ~^~ ~^~

~ W . I . L . L . Y . U . M ~
wOrLd WiDe WhAt?

 

[jfischer]

You can put a CheckBox control on your report in the Detail section. Delete the label portion of the field that Access may add automatically. Then, in the OnFormat event for the Detail section you can set the value of the CheckBox to True or False depending on your criteria. For example:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
  Me!chkSpecialID = (Left(Me!UserID, 1) = "Z")
End Sub

 

[bnath001]

Jfischer,

As per your suggestion, I tried the following code:

Me!chk_tickit = True.

At the time of Me! it is supposed to show all the controls but it doesn't . How to access the check box control which is in a detail section in a report.
Appreciate your suggestion.

thanks
nath

 

[jfischer]

Nath,

What do you mean by "at the time of Me!"? "Me" is a shorthand notation for a form or report when it is open and has the focus. It sounds like you have other problems than the CheckBox control. Can you provide more details about your report design?

John

 

[bnath001]

JOhn

I used rpt_test!chk_test = True. It gives an error object required. I have a check box control in the detail section and I need check this check box control when the report is run.

thank you
nath