Unbound Form for a JPG

[Guest]

I'm using SQL statements to populate an
Unbound Form with Unbound Controls.

If I store in the Field "APic" the text value C:\Bob.jpg....

Which Control do I use to display that so it links to that
File...NOTE: The JPG Files will be referenced to a
Server...not the C: Drive.

TIA - Bob

 

[Guest]

Hi,
you would be using an image control. Add it from the toolbox in design view
of your form...it will ask you for an image...just add one you have on your
harddrive...then you can utilize the Picture property of this control on the
on current and the after update event of the control which holds the full
path to your images e.g.:

Me!YourImageControl.Picture = Me!ControlWhichHoldsPath

HTH
Good luck

 

[Guest]

Thank you...but the Unbound textbox I'm using to populate w/ "C\Bob5.jpg"
reads as "Empty".

Any ideas?

TIA - Bob

 

[Guest]

THANK you...I'm using code to populate an Unbound Textbox w/ "C:\Bob5.jpg"
but it reads as "Empty".

Any ideas?

TIA - Bob

 

[Guest]

MY ERROR - Mea Culpa...I left out the "!" to identify the field.

THANK you for explaining this.

Bob