Reports - only printing (displaying) if data has been entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hope you can help me.

I have inherited quite a large access database upon which I now need to do
some more work. The database is based upon a questionnaire administered to
2500 students. One part of the questionnaire examined their supplement
(vitamins) intake. It listed about 150 different supplements and asked them
to record the freq at which they took them (if at all) and the amount. It
then gave an 'others' box in which they detailed supplements they took that
werent listed - not an ideal questionnaire but as I said, it was inherited.

I would like to create a report that will detail who took what. I have tried
a couple of times, and error messages tell me it is too big. If I only do the
records of a few students at a time it does create a report. but the report
lists off all the fields (150 of them - even if they are empty! Is there a
way to create a report that would only display a field if data had been
entered for that field?

Am using MS ACCESS 2000

I hope this makes some sense? I am sure it is something simple - I just cant
see it.
 
Eils said:
I have inherited quite a large access database upon which I now need to do
some more work. The database is based upon a questionnaire administered to
2500 students. One part of the questionnaire examined their supplement
(vitamins) intake. It listed about 150 different supplements and asked them
to record the freq at which they took them (if at all) and the amount. It
then gave an 'others' box in which they detailed supplements they took that
werent listed - not an ideal questionnaire but as I said, it was inherited.

I would like to create a report that will detail who took what. I have tried
a couple of times, and error messages tell me it is too big. If I only do the
records of a few students at a time it does create a report. but the report
lists off all the fields (150 of them - even if they are empty! Is there a
way to create a report that would only display a field if data had been
entered for that field?

Am using MS ACCESS 2000
Click to expand...


Make each text box's and their section's CanShrink property
to Yes.

If that's not sufficient, then, for each text box, add a
line of code to the Format event of the section containing
the text boxes:

Me.textbox1.Visible = Not IsNull(Me.textbox1)
 
Back
Top