-
Feb 8th, 2006, 01:46 PM
#1
Thread Starter
Fanatic Member
Printing Issues - Why is this double spacing?
The following code works but it prints the records double-spaced. I can't figure out why.
VB Code:
rsCancel.Open strSQL, Oracon, adOpenForwardOnly, adLockReadOnly
With rsCancel
If .BOF <> True And .EOF <> True Then
'Print the headings for the report
PrintHeadings
.MoveFirst
intCount = 0
intLineCount = 0
Do Until .EOF
'Print Doctor Name
Printer.Print .Fields!Location;
'Set the CurrentX property to print in the date column, then write the date
Printer.CurrentX = 2180
If IsNull(.Fields!DOC_NAME) Then
Printer.Print .Fields!NONDOC_CLINIC_NAME;
Else
Printer.Print .Fields!DOC_NAME
End If
'Set the CurrentX property to print in the location column, then write the location
Printer.CurrentX = 5452
Printer.Print .Fields!Clinic_Date;
'Set the CurrentX property to print in the reasons column, then write the cancellation reason
Printer.CurrentX = 7954
Printer.Print .Fields!Cancel_Reason
intLineCount = intLineCount + 1
'Once 50 lines have been printed, start a new page
If intLineCount = 50 Then
PrintFooter
Printer.NewPage
PrintHeadings
intLineCount = 0
End If
.MoveNext
Loop
End If
PrintFooter
Printer.EndDoc
End With
-
Feb 8th, 2006, 02:00 PM
#2
Re: Printing Issues - Why is this double spacing?
I would guess that the Cancel field is too long for the width of the page, causing it to wrap.
-
Feb 8th, 2006, 02:11 PM
#3
Thread Starter
Fanatic Member
Re: Printing Issues - Why is this double spacing?
The problem was that I forgot the ";" after printing the doc_name field so after taking a closer look I could see it was printing each docname on a new line.
-
Feb 8th, 2006, 02:43 PM
#4
Re: Printing Issues - Why is this double spacing?
Originally Posted by The_Grudge
The problem was that I forgot the ";" after printing the doc_name field so after taking a closer look I could see it was printing each docname on a new line.
So, is this resolved?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|