Report.PSet method (Access)
The PSet method sets a point on a Report object to a specified color when the Print event occurs.
expression.PSet (Flags, x, y, Color)
expression A variable that represents a Report object.
|Flags||Required||Integer||A keyword that indicates that the coordinates are relative to the current graphics position given by the settings for the CurrentX and CurrentY properties of the Object argument.|
|x||Required||Single||The horizontal coordinate of the point to set.|
|y||Required||Single||The vertical coordinate of the point to set.|
|Color||Required||Long||The RGB (red-green-blue) color to set the point to. If this argument is omitted, the value of the ForeColor property is used. You can also use the RGB function or QBColor function to specify the color.|
The size of the point depends on the DrawWidth property setting. When the DrawWidth property is set to 1, the PSet method sets a single pixel to the specified color. When the DrawWidth property is greater than 1, the point is centered on the specified coordinates.
When you apply the PSet method, the CurrentX and CurrentY properties are set to the point specified by the x and y arguments.
To clear a single pixel with the PSet method, specify the coordinates of the pixel and use &HFFFFFF (white) as the Color argument.
The following example uses the PSet method to draw a line through the horizontal axis of a report.
To try this example in Microsoft Access, create a new report. Set the OnPrint property of the Detail section to [Event Procedure]. Enter the following code in the report's module, and then switch to Print Preview.
Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Dim sngMidPt As Single, intI As Integer ' Set scale to pixels. Me.ScaleMode = 3 ' Calculate midpoint. sngMidPt = Me.ScaleHeight / 2 ' Loop to draw line down horizontal axis pixel by pixel. For intI = 1 To Me.ScaleWidth Me.PSet(intI, sngMidPt) Next intI End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.