Suppress Line Printing on Null Fields

[Guest]

I have a Report I have a test for students to print with 19 possible lines.
Each Text Box prints on it's own line.

I have this example test code:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If IsNull(Me!AddressB) Then
Reports!rptHSchoolNoTest1.Section(acDetail).Visible = False
Else
Reports!rptHSchoolNoTest1.Section(acDetail).Visible = True
End If

End Sub

I have it on Format for the Detail Section. I tried using the can shrink
property and got the same results.

Thanks in advance!

Granny the Teacher

 

[Guest]

Granny, you may be better off with an underlying query behind the report to
in fact only show the records with results. You can control that from the
criteria line of the query design. The way you have the report designed, it
sounds like you will use space for the record whether or not there is data to
show. Try contolling that at the query level itself. Let me know if I can
help further.

Destin Richter
(e-mail address removed)

 

[Guest]

Destin;
Thanks for getting back. The application is actually a Texas State
required test. If a student scores between 70 and 75, that student has a
chance to answer the questions he or she had in-correct.

I just wanted the lines to print that had the question in the
field. The table is updated by the CBE, therefore I am not permitted to
change the record layout.

They want the district to purchase IBM machines that have no
problem with this type of scenario, however we are a fairly poor district
outside of El Paso. (I noticed the NewMexico on your link) and lack the
funds to purchase an AS400.

I got it to work by building a table, but I have over 190 append
queries and I know there is a better way, but I just cannot think of one.
This is one of those applications where a flat file design may be better than
a database design.

Now that you have an idea what the application is, you may be able
to help me out. If not thanks a lot for your effort.

 

[Guest]

GrandMaMa, thanks for the additional information. There are several ways you
can do this, and I don't know what kind of control you have over the app.
For each answer between the 70-75 percent range, there could be an "on exit"
function that checks off another field (yes/no box) in order to reprint those
questions later. I don't think I'd be able to help more specifically without
knowing the whole layout there. Stay in touch if you think I can help.

Destin Richter
(e-mail address removed)