autoresize rectangle

G

Guest

Hi. I want to put a rectangle in Details section. But details can grow or
shrink. I can I tell to that control that it must have the same size as
details dection??

Regards,
Marco
 
M

Marshall Barton

Marco said:
Hi. I want to put a rectangle in Details section. But details can grow or
shrink. I can I tell to that control that it must have the same size as
details dection??


Use the detail section's Print event:

Me.Line ((0,0)-Step(Me.Width,Me.Section(0).Height), , B
 
L

luis.a.roman

Use the detail section's Print event:

Me.Line ((0,0)-Step(Me.Width,Me.Section(0).Height), , B


This is a very handy advise. Can you let me know what B stands for? Or
what does it reference. Or explain the code.

Thanks - Luis
 
M

Marshall Barton

This is a very handy advise. Can you let me know what B stands for? Or
what does it reference. Or explain the code.


Normally, I would refer you to the VBA Help topic for the
Line method, but the topic looks like a copy/paste from a
different language and doesn't make sense in VBA.

The B probably stands for Box and indicates that you want to
use the coordinates as the diagonal corners of a rectangle.

Rather than go on, here's a copy of the A97 Help topic:
-----------------------------------------------------------------------------
The Line method draws lines and rectangles on a Report
object when the Print event occurs.

Syntax

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.
 
L

luis.a.roman

This is a very handy advise. Can you let me know what B stands for? Or
what does it reference. Or explain the code.

Normally, I would refer you to the VBA Help topic for the
Line method, but the topic looks like a copy/paste from a
different language and doesn't make sense in VBA.

The B probably stands for Box and indicates that you want to
use the coordinates as the diagonal corners of a rectangle.

Rather than go on, here's a copy of the A97 Help topic:
---------------------------------------------------------------------------­--
The Line method draws lines and rectangles on a Report
object when the Print event occurs.

Syntax

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 rectangleis 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.

Thank you for the information. Also, tried the code and it works
great. Thank you again for sharing your knowledge and expertise.

Luis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top