Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / June 2007

Tip: Looking for answers? Try searching our database.

Frustrated re Line method

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bruce - 26 Jun 2007 16:04 GMT
Hello all,

Does someone out there have a better reference on how to use the
report Line method than what is in the help file for Access 2003?
Maybe I'm just misunderstanding but it seems there are typos in the
help for this particular method.  For example there is a reference to
a required 'flags' parameter but no explanation of what that parameter
is.  Also the starting and ending XY coordinates for in the example
seem to be expressed as ordered pairs subtracted from each other
instead of as individual parameters as the help implies they should
be.  Finally the example uses a mysterious ending parameter, 'B',
after the color parameter that is not explained.  At any rate, if
anyone has a pointer to better help or better examples of using Line
I'd appreciate it.  Thanks.

Bruce
Marshall Barton - 26 Jun 2007 18:12 GMT
>Does someone out there have a better reference on how to use the
>report Line method than what is in the help file for Access 2003?
[quoted text clipped - 8 lines]
>anyone has a pointer to better help or better examples of using Line
>I'd appreciate it.

The Line, Circle and PSet Help topics have been a mess since
A2K.  The method descriptions look like a copy paste from
some other language, but the examples are correct.  Just in
case you do not have the A97 Help topic handy, here's a copy
(mangled by the usual line wrapping):

object.Line [[Step](x1, y1)] – [Step](x2, y2)[, [color][,
B[F]]]

You can use this method only in an event procedure or a
macro specified by the OnPrint or OnFormat event property
for a report section, or the OnPage event property for a
report.

The Line method has the following arguments.

Argument    Description
object    The Report object on which the line or rectangle is
to be drawn.
Step    A keyword that indicates the starting point
coordinates are relative to the current graphics position
given by the settings for the CurrentX and CurrentY
properties of the object argument.
x1, y1    Single values indicating the coordinates of the
starting point for the line or rectangle. The Scale
properties (ScaleMode, ScaleLeft, ScaleTop, ScaleHeight, and
ScaleWidth) of the Report object specified by the object
argument determine the unit of measure used. If this
argument is omitted, the line begins at the position
indicated by the CurrentX and CurrentY properties.
Step    A keyword that indicates the end-point coordinates are
relative to the line's starting point.
x2, y2    Single values indicating the coordinates of the end
point for the line to draw. These arguments are required.
color    A Long value indicating the RGB (red-green-blue) color
used to draw the line. 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.
B    An option that creates a rectangle by using the
coordinates as opposite corners of the rectangle.
F    F cannot be used without B. If the B option is used, the F
option specifies that the rectangle is filled with the same
color used to draw the rectangle. If B is used without F,
the rectangle is filled with the color specified by the
current settings of the FillColor and BackStyle properties.
The default value for the BackStyle property is Normal for
rectangles and lines.
Remarks

To connect two drawing lines, make sure that one line begins
at the end point of the previous line.
The width of the line drawn depends on the DrawWidth
property setting. The way a line or rectangle is drawn on
the background depends on the settings of the DrawMode and
DrawStyle properties.
When you apply the Line method, the CurrentX and CurrentY
properties are set to the end point specified by the x2 and
y2 arguments.

--
Marsh
Bruce - 29 Jun 2007 22:26 GMT
> >Does someone out there have a better reference on how to use the
> >report Line method than what is in the help file for Access 2003?
[quoted text clipped - 70 lines]
> --
> Marsh

Thank you.  I also found up-to-date help in the MSDN online in case
anyone else is looking for this.

Bruce
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.