DBgrid printing??

[Thenrich]

Does anybody know if there is a way to print just the information in a DBgrid from a form and not the complete form??

[Aaron Young]

You could just print the Info from the Underlying DataSource which the Grid is Bound to, eg.

Private Sub Command1_Click()
    Dim sLine As String
    Dim iIndex As Integer
    With Data1.Recordset
        .MoveFirst
        While Not .EOF
            sLine = ""
            For iIndex = 0 To .Fields.Count - 1
                sLine = sLine & Chr(9) & .Fields(iIndex)
            Next
            Printer.Print Mid$(sLine, 2)
            .MoveNext
        Wend
    End With
    Printer.EndDoc
End Sub

------------------
Aaron Young
Analyst Programmer
[email protected]
[email protected]

[MartinLiss]

If you just want to see the info that is currently being displayed in your grid and you have a "Print" button on the form, you can put code behind that button to temporarily make everything except the grid .Visible = False, and then make them visible again when printing is done.

------------------
Marty