Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

VB Controls in VBA

2 views
Skip to first unread message

HB

unread,
Aug 11, 2003, 1:11:18 PM8/11/03
to
Please Help

Is there any way I can use the Circle Control from Visual Basic in my VBA in
Access. I need to make ellipses etc in Form view In MS access but it can't
be a dwg - must be a control. Access does not have a circle control in its
forms.

Thanks in advance.


jim_w

unread,
Aug 11, 2003, 5:11:00 PM8/11/03
to
hi HB,

AFAIK, the vb "circle" (or shape) is an intrinsic(?), light-weight(?),
implicit(?) control, in other words that is not a control per se, vb just
draws the circle on your form for you. As such, there is no "control" to
use with vba.

However, since you asked in an api group, there is an api way to do it, by
calling the ellipse api.

If you don't like calling api's, then you could just use a simple graphics
package (paint will do) and create a circle graphic, then show it using an
image control (which forms 2.0 DOES have)...

cheers, jw


"HB" <frm...@telus.net> wrote in message
news:W6QZa.1406$Rm1.686@edtnps84...

Dave

unread,
Aug 12, 2003, 5:53:16 AM8/12/03
to
Access help files ...

Circle Method - draw ellipses using aspect ratio
Line Method - lines and rectangles
Print Method - Text output

also have a look at the DrawMode, DrawStyle, DrawWidth properties etc.

The help mentions these functions in relation to a report, but maybe you can
add a subreport to your form and use it as a drawing area.

hth,
Dave


"jim_w" <jwarrington*noSteekin*@*Spam*worldnet.att.net> wrote in message
news:EDTZa.94225$3o3.6...@bgtnsc05-news.ops.worldnet.att.net...

0 new messages