I found some VB code to printout a richtext field and I'm trying to
adapt it to MS Access 2000. I think there might be some small changes
to make the adaption between VB versions. Also my OS is Windows XP.
The website I found the code is:
http://www.developerfusion.com/show/244/ See the code below. There is
also some code found at http://www.freevbcode.com/ShowCode.asp?ID=1028
I would appreciate someone's help in getting this to work.
Instructions and Code:
=============== =============
1. Start a new project in the Visual Basic 32-bit edition. Form1 is
created by default.
2. Put a CommandButton and a RichTextBox control on Form1.
3. Add the following code to Form1:
=============== =============== =============== =============== =====
Option Explicit
Private Sub Form_Load()
Dim LineWidth As Long
' Initialize Form and Command button
Me.Caption = "Rich Text Box WYSIWYG Printing Example"
Command1.Move 10, 10, 600, 380
Command1.Captio n = "&Print"
' Set the font of the RTF to a TrueType font for best results
RichTextBox1.Se lFontName = "Arial"
RichTextBox1.Se lFontSize = 10
' Tell the RTF to base it's display off of the printer
LineWidth = WYSIWYG_RTF(Ric hTextBox1, 1440, 1440)
'1440 Twips=1 Inch
' Set the form width to match the line width
Me.Width = LineWidth + 200
End Sub
Private Sub Form_Resize()
' Position the RTF on form
RichTextBox1.Mo ve 100, 500, Me.ScaleWidth - 200, _
Me.ScaleHeight - 600
End Sub
Private Sub Command1_Click( )
' Print the contents of the RichTextBox with a one inch margin
PrintRTF RichTextBox1, 1440, 1440, 1440, 1440 ' 1440 Twips = 1
Inch
End Sub
=============== =============== =============== =============== =====
4. Insert a new standard module into the project, Module1.bas is
created by default.
5. Add the following code to Module1:
=============== =============== =============== =============== =====
Option Explicit
Private Type Rect
Left As Long
Top As Long
Right As Long
Bottom As Long
End Type
Private Type CharRange
cpMin As Long ' First character of range (0 for start of doc)
cpMax As Long ' Last character of range (-1 for end of doc)
End Type
Private Type FormatRange
hdc As Long ' Actual DC to draw on
hdcTarget As Long ' Target DC for determining text formatting
rc As Rect ' Region of the DC to draw to (in twips)
rcPage As Rect ' Region of the entire DC (page size) (in
twips)
chrg As CharRange ' Range of text to draw (see above declaration)
End Type
Private Const WM_USER As Long = &H400
Private Const EM_FORMATRANGE As Long = WM_USER + 57
Private Const EM_SETTARGETDEV ICE As Long = WM_USER + 72
Private Const PHYSICALOFFSETX As Long = 112
Private Const PHYSICALOFFSETY As Long = 113
Private Declare Function GetDeviceCaps Lib "gdi32" ( _
ByVal hdc As Long, ByVal nIndex As Long) As Long
Private Declare Function SendMessage Lib "USER32" _
Alias "SendMessag eA" _
(ByVal hWnd As Long, ByVal msg As Long, ByVal wp As Long, _
lp As Any) As Long
Private Declare Function CreateDC Lib "gdi32" Alias "CreateDCA" _
(ByVal lpDriverName As String, ByVal lpDeviceName As String, _
ByVal lpOutput As Long, ByVal lpInitData As Long) As Long
''''''''''''''' ''''''''''''''' ''''''''''''''' ''''''''''''''' ''''''''''''
'
' WYSIWYG_RTF - Sets an RTF control to display itself the same as
it
' would print on the default printer
'
' RTF - A RichTextBox control to set for WYSIWYG display.
'
' LeftMarginWidth - Width of desired left margin in twips
'
' RightMarginWidt h - Width of desired right margin in twips
'
' Returns - The length of a line on the printer in twips
''''''''''''''' ''''''''''''''' ''''''''''''''' ''''''''''''''' '''''''''''
Public Function WYSIWYG_RTF(RTF As RichTextBox, _
LeftMarginWidth As Long, _
RightMarginWidt h As Long) As Long
Dim LeftOffset As Long, LeftMargin As Long, RightMargin As Long
Dim LineWidth As Long
Dim PrinterhDC As Long
Dim r As Long
' Start a print job to initialize printer object
Printer.Print Space(1)
Printer.ScaleMo de = vbTwips
' Get the offset to the printable area on the page in twips
LeftOffset = Printer.ScaleX( GetDeviceCaps(P rinter.hdc, _
PHYSICALOFFSETX ), vbPixels, vbTwips)
' Calculate the Left, and Right margins
LeftMargin = LeftMarginWidth - LeftOffset
RightMargin = (Printer.Width - RightMarginWidt h) - LeftOffset
' Calculate the line width
LineWidth = RightMargin - LeftMargin
' Create an hDC on the Printer pointed to by the Printer object
' This DC needs to remain for the RTF to keep up the WYSIWYG
display
PrinterhDC = CreateDC(Printe r.DriverName, Printer.DeviceN ame, 0,
0)
' Tell the RTF to base it's display off of the printer
' at the desired line width
r = SendMessage(RTF .hWnd, EM_SETTARGETDEV ICE, PrinterhDC, _
ByVal LineWidth)
' Abort the temporary print job used to get printer info
Printer.KillDoc
WYSIWYG_RTF = LineWidth
End Function
''''''''''''''' ''''''''''''''' ''''''''''''''' ''''''''''''''' ''''''''''''
'
' PrintRTF - Prints the contents of a RichTextBox control using the
' provided margins
'
' RTF - A RichTextBox control to print
'
' LeftMarginWidth - Width of desired left margin in twips
'
' TopMarginHeight - Height of desired top margin in twips
'
' RightMarginWidt h - Width of desired right margin in twips
'
' BottomMarginHei ght - Height of desired bottom margin in twips
'
' Notes - If you are also using WYSIWYG_RTF() on the provided RTF
' parameter you should specify the same LeftMarginWidth and
' RightMarginWidt h that you used to call WYSIWYG_RTF()
''''''''''''''' ''''''''''''''' ''''''''''''''' ''''''''''''''' ''''''''''''
Public Sub PrintRTF(RTF As RichTextBox, LeftMarginWidth As Long, _
TopMarginHeight , RightMarginWidt h, BottomMarginHei ght)
Dim LeftOffset As Long, TopOffset As Long
Dim LeftMargin As Long, TopMargin As Long
Dim RightMargin As Long, BottomMargin As Long
Dim fr As FormatRange
Dim rcDrawTo As Rect
Dim rcPage As Rect
Dim TextLength As Long
Dim NextCharPositio n As Long
Dim r As Long
' Start a print job to get a valid Printer.hDC
Printer.Print Space(1)
Printer.ScaleMo de = vbTwips
' Get the offsett to the printable area on the page in twips
LeftOffset = Printer.ScaleX( GetDeviceCaps(P rinter.hdc, _
PHYSICALOFFSETX ), vbPixels, vbTwips)
TopOffset = Printer.ScaleY( GetDeviceCaps(P rinter.hdc, _
PHYSICALOFFSETY ), vbPixels, vbTwips)
' Calculate the Left, Top, Right, and Bottom margins
LeftMargin = LeftMarginWidth - LeftOffset
TopMargin = TopMarginHeight - TopOffset
RightMargin = (Printer.Width - RightMarginWidt h) - LeftOffset
BottomMargin = (Printer.Height - BottomMarginHei ght) - TopOffset
' Set printable area rect
rcPage.Left = 0
rcPage.Top = 0
rcPage.Right = Printer.ScaleWi dth
rcPage.Bottom = Printer.ScaleHe ight
' Set rect in which to print (relative to printable area)
rcDrawTo.Left = LeftMargin
rcDrawTo.Top = TopMargin
rcDrawTo.Right = RightMargin
rcDrawTo.Bottom = BottomMargin
' Set up the print instructions
fr.hdc = Printer.hdc ' Use the same DC for measuring and
rendering
fr.hdcTarget = Printer.hdc ' Point at printer hDC
fr.rc = rcDrawTo ' Indicate the area on page to draw
to
fr.rcPage = rcPage ' Indicate entire size of page
fr.chrg.cpMin = 0 ' Indicate start of text through
fr.chrg.cpMax = -1 ' end of the text
' Get length of text in RTF
TextLength = Len(RTF.Text)
' Loop printing each page until done
Do
' Print the page by sending EM_FORMATRANGE message
NextCharPositio n = SendMessage(RTF .hWnd, _
EM_FORMATRANGE, True, fr)
If NextCharPositio n >= TextLength Then Exit Do 'If done then
exit
fr.chrg.cpMin = NextCharPositio n ' Starting position for next
page
Printer.NewPage ' Move on to next page
Printer.Print Space(1) ' Re-initialize hDC
fr.hDC = Printer.hDC
fr.hDCTarget = Printer.hDC
Loop
' Commit the print job
Printer.EndDoc
' Allow the RTF to free up memory
r = SendMessage(RTF .hWnd, EM_FORMATRANGE, False, ByVal _
CLng(0))
End Sub
=============== =============== =============== =============== =====
6. Save the project.
7. Run the project.
8. Enter or paste some text into the RichTextBox.
9. Press the Print command button. Note that the printed output should
word-wrap at the same locations as displayed on the screen. Also, the
output should be printed with the specified one-inch margin all
around.
