ms access dynamic reporting

  • Thread starter Thread starter seth rosenberg
  • Start date Start date
S

seth rosenberg

i am a novice at microsoft access reporting (2007) I am trying to create a report that has sections or layers. I want specific sections or layers visable on a condition.. for example, within the data are a couple of yes no questions, if one of the questions are Yes, I want for that record another section to appear..

example, data for an inventory listing, where the report will generate a single page for each item, If there the item is flagged with a picture atachment (yes no option) then I want the report to include the picture, if not, I dont' want the space alocated for the picture to exist.. so the report will perhaps shift up.

thanks in advance.

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx
 
Each section, and some of the controls, has a 'Can Shrink' property.
Experiment with it to see if it behaves as desired.
 
try setting the visible property of the control for the picture to match the
flag field's value in the format event of the relevant section. Also turn on
can shrink/can grow for the section. You would have a line of VBA that would
look something like the following (replace generic names with actual control
names).

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.PictureControlName.Visible = Me.PictureFlagName
End Sub


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top