Control To Show Line Drawing

[Frank Wagner]

I am totally stymied in my attemps to create a control on my Access 2000 form
that allows me to display a series of line drawings that depend on the ID
number of the record being displayed.

When I create an OLE field and insert the Line Drawing from Paint, the only
type of control I can find that displays the drawing is a "Bound Control
Frame" that is created by Auto-Form. The problem with this is that I cannot
change the properties using VBA code to make the control invisible when
there is not a picture, and nobody in the discussion group seems to know how
to correct the problem.

If this type of control is not usable, is there any other type of control
that will display the line drawings, and can be hidden upon request.

Any help would be appreciated, so far I am stuck

Thanks

Frank Wagner
(e-mail address removed)

 

[Minton M]

I am totally stymied in my attemps to create a control on my Access 2000 form
that allows me to display a series of line drawings that depend on the ID
number of the record being displayed.

When I create an OLE field and insert the Line Drawing from Paint, the only
type of control I can find that displays the drawing is a "Bound Control
Frame" that is created by Auto-Form. The problem with this is that I cannot
change the properties using VBA code to make the control invisible when
there is not a picture, and nobody in the discussion group seems to know how
to correct the problem.

If this type of control is not usable, is there any other type of control
that will display the line drawings, and can be hidden upon request.

Any help would be appreciated, so far I am stuck

Thanks

Frank Wagner
(e-mail address removed)

I had a simple problem a while back and found the solution was to use
a free vector graphics ActiveX control, which worked fairly well. I've
searched for the component I used but can only find commercials ones
now but if you look around, you may find one. I was trying to draw
circles to represent tables on a floorplan for a POS project and I
spent more time figuring out how to draw the freaking circles than
doing anything else.

Sorry I can't remember the name of the component but if I find it
again, I'll update this thread.

-- James

I had sleepless nights dreaming about those damned circles...

 

[Frank Wagner]

Milton:

Thanks for the input. What I'm also thinking about now is placing the
picture in a subform that contains only the picture in a Bound Object Frame.
I can then make the subform visible and invisible as needed even though I
can't change the Picture control.

Thanks Again

 

[Stephen Lebans]

You really need to learn how to search GoogleGroups effectively as this
issue has surfaced in the NG's before.

The air code below assumes a Bound OLE Frame control named
"OLEBoundAutosize".
If IsNull(Me.OLEBoundAutosize.Value) Then
Me.OLEBoundAutosize.Visible = False
Else
Me.OLEBoundAutosize.Visible = True
End If




--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Frank Wagner]

Stephen:

Thanks for the code. Is GoogleGroups separate from this. If so how do I
find it?

You use the term NG, and I don't know what that means

 

[Douglas J. Steele]

Google Groups is an archive of all newsgroup answers.
http://groups.google.com/advanced_search