Control options for Exporting and Printing

[FriQenstein]

Greetings all,

I'm nearing the end of my DB design and almost ready for roll out.

I was asked if it would be possible to display certain information on a Report at times and not display it at other times.
For example: Report for a list of inventory items has a category for Consignment. They only want the Consignment company listed for internal use and not for external use.


So my Report has an Export to PDF button, and a Print button.

What I'm wondering is, what is the best way to allow the user to choose whether or not to display the Consignment field on the report or export file? Should I use a check box on the Report, or a radio button, or should I just make additional buttons for Export and Print that allow the user to select if/when they want that Consignment value displayed?

I'm not too familiar with using check boxes and radio buttons in Access, but I know what they are and how they work. I'm just looking for the simplest solution for this particular scenario.
I'm guessing creating a second set of buttons would be easier, however I would then most likely l need to create a second Report that doesn't show the Consignee field. Just a simple copy and paste option with changes to the output fields should suffice I guess.

Thoughts?
Thanks.

[pbaldy]

You could probably make any of those options work, so whichever fits your app best. A second button wouldn't have to open a different report, it could pass something in OpenArgs. Code in the format event of the section containing that control can check a form or OpenArgs and hide/display that control as appropriate.

[FriQenstein]

I've added a Checkbox to the Report which allows the user to select/deselect the field using:

Private Sub ChkBox1_AfterUpdate()If Me.ChkBox1 = True Then
  Me.Consignee.Visible = True
  Me.Label11.Visible = True
Else
  Me.Consignee.Visible = False
  Me.Label11.Visible = False
End If
End Sub

This appears to be working so far.

Thanks.

[pbaldy]

Okay. Holds that setting when you export or print?

[FriQenstein]

Indeed it does. I've tested it with the Export to PDF and in the Print Preview window... I haven't actually printed it yet, but the preview looks to be OK.