checkbox in report

[billa856]

Hi,
My Project is in MS Access 2002.
In that i have one form in which I am using several textboxes,combo boxes and (three) checkboxes.
in that form I have BillTo address and ShipTo address and Thirdparty BillTo address.
Now I have to enter BillTo address.
Case 1:
If BillTo and ShipTo addresses are same then i click on first checkbox then it will automatically enter the ShipTo Address same as BillTo address.
Case 2:
If BillTo and ShipTo addresses are different then, there are two more checkboxes.
If I click on first one then it will enter BillTo addredd as ThirdParty BillTo address and
if I click on second one then it will enter ShipTo address as ThirdPartyBillT o address.
Now after that I save all the details in table.Then I will generate report from that details.
Now I want to show checkboxes also in Report.So If check any checkbox in form and then it will show in report also.I don't know how to do this?

[JustJim]

Hi,
My Project is in MS Access 2002.
In that i have one form in which I am using several textboxes,combo boxes and (three) checkboxes.
in that form I have BillTo address and ShipTo address and Thirdparty BillTo address.
Now I have to enter BillTo address.
Case 1:
If BillTo and ShipTo addresses are same then i click on first checkbox then it will automatically enter the ShipTo Address same as BillTo address.
Case 2:
If BillTo and ShipTo addresses are different then, there are two more checkboxes.
If I click on first one then it will enter BillTo addredd as ThirdParty BillTo address and
if I click on second one then it will enter ShipTo address as ThirdPartyBillT o address.
Now after that I save all the details in table.Then I will generate report from that details.
Now I want to show checkboxes also in Report.So If check any checkbox in form and then it will show in report also.I don't know how to do this?

Hi,
In Case 2, I think that you might want to consider using either radio buttons or toggle buttons in an option group rather than individual check boxes.

Otherwise, if you put a check box on a report, it will preview/print either checked or not depending on the value.

(They don't actually look all that good on a report, and there are other methods of putting nice looking check marks in a box, but we can go into that later if you want to)

Jim

[billa856]

Hi,
In Case 2, I think that you might want to consider using either radio buttons or toggle buttons in an option group rather than individual check boxes.

Otherwise, if you put a check box on a report, it will preview/print either checked or not depending on the value.

(They don't actually look all that good on a report, and there are other methods of putting nice looking check marks in a box, but we can go into that later if you want to)

Jim

i just want to know the method how can i put check box in my report.I already change that check box to toggle buttons, u are telling me.
Thanks for ur reply.

[JustJim]

i just want to know the method how can i put check box in my report.I already change that check box to toggle buttons, u are telling me.
Thanks for ur reply.

In report design view, just drag the appropriate field from the field list onto the report. The check box will appear 'checked' if the value is true or empty if it is false.

Jim