skipping a line

[toptech]

Hi There.

Does anyone know how to skip a line when printing.

I would like to print line1 all the time, but not print line2 if it is blank.

Any help would be appreciated.

Thanks in advance.

Jeff

Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.

 

[dhookom]

This isn't clear. If you want controls and sections to shrink if values are null then set their Can Shrink properties to Yes.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[toptech]

Hi Duane.

Thanks for your response.

To make myself more clear, I have the following:

I have 2 fields.
Decription1 and decription2.

Both fields are in the detail section of the report, one below the other on 2 lines.

Let's say I have 10 records to print.
Normally the result for printing would be 20 lines.

However, if decription2 of 5 of the 10 records are null,
the result should only print 15 lines not 20.

10 of decription1 lines and 5 of description2 lines with no blank lines.

There can be no blank lines to be printed.

I hope this makes my request clearer.

Regards,

Jeff

Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.

 

[SgtJarrow]

Set the CanShrink Property for both the Description2 control and the Details section of the report.

You might also want to add code to the OnPrint event of the Details section that says something:

If Me.Description2 = "" or IsNull(Me.Description2) Then
Me.Description2.Visible = False
Else
Me.Description2.Visible = True
End If

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[dhookom]

TopTech,
I appreciate your reply but it didn't mention if you tried my suggestion [Blue]"If you want controls and sections to shrink if values are null then set their Can Shrink properties to Yes"[/blue] or your results.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]