I need to print off rows in a MS Flex Grid returned from an embedded SQL query. I can at the moment print each row off using a for loop:
Private Sub cmdPrint_Click()
Dim PrintString As String, iRows As Integer, jCols As Integer

For iRows = 0 To fgStudentDetails.Rows - 1
PrintString = ""

For jCols = 0 To fgStudentDetails.Cols - 1
PrintString = PrintString & fgStudentDetails.TextMatrix(iRows, jCols)
If jCols < fgStudentDetails.Cols - 1 Then
PrintString = PrintString & ","
End If
Next
Printer.Print PrintString
Printer.EndDoc
Next

End Sub

However, the end result is a rather unsitely list of whatever is in the flex grid separated by comma's. I need to do formatting commands for EACH row that is returned but am unsure of where to incorporate them in the above query. Things like orientation, scalemode, currentX and Y, etc etc.

Can anyone assist me? I have searched the forums to no avail!!

Please help, i know there are people with considerable knowledge !!

Many thx in advance