By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,251 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

checkbox in report

100+
P: 101
Hi,
My Project is in MS Access 2002.
In that i have one form in which I am using several textboxes,comboboxes 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 ThirdPartyBillTo 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?
Mar 11 '08 #1
Share this Question
Share on Google+
3 Replies


JustJim
Expert 100+
P: 407
Hi,
My Project is in MS Access 2002.
In that i have one form in which I am using several textboxes,comboboxes 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 ThirdPartyBillTo 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
Mar 20 '08 #2

100+
P: 101
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.
Mar 20 '08 #3

JustJim
Expert 100+
P: 407
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
Mar 21 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.