Private Sub cmdprint_Click()

i am searching the code of the command button for printing, at the above.. now,
textidno.text =
textborrowersname.text =

what is code after the " = "

printer.print text1.text

use it. or more then ask

Make use of the common dialog control (Under 'Projects/Components/Microsoft Common Dialog Control 6.0 (spxx) xx being your service pack utilized'. When clicking on the command button -

cdlgPrint.PrinterDefault = True 'If using the default printer
cdlgPrint.Orientation = cdlLandscape 'Depending on the orientation needed, portrait or landscape
cdlgPrint.Print Text1.Text

Play with all the different properties to ensure a perfect print.