Access fails to set a image control

[GraeagleBill]

I have a popup form that contains an image control. The OnOpen code attempts to assign a jpg file as the picture property but fails with a message that Access can't find the picture.

Me.imgFormImage.Picture = DefaultImage

I've examined the "DefaultImage" string to verify the fully qualified path to the file. If I assign that same file via the browse in the control property sheet Access has no problem.



Any ideas why the Assignment statement shown above would fail?

[Minty]

Try moving it to the on load event.

The controls / recordset aren't loaded at open.

[GraeagleBill]

I've graduated to the famous "2220 - Can't Open"


I created a BMP version of DefaultPic and set the Picture property without any errors. I can only assume that Access is having difficulty with rendering a jpg file? I still need to find a solution to this caper, as there will be follow-on code that will need to change the picture per a user request.

[Micron]

Open will work - the image control isn't bound so it's not loading anything. Setting any control or form property on Open should work.
There is likely something wrong with your string or the variable that contains it.

[GraeagleBill]

DefaultImage is Dim'd As String
Here's the OPEN code that sets the string, folder locations being obtained from the app's settings. The string appears correct when viewed in Debug.


Same error even if I eliminate any question about the string variable.

[June7]

Try using ControlSource instead of Picture property.

I've never used Picture property for dynamic display of image.

[Welshgasman]

I have to ask?

Why set a control to it's default on Load of the form?

I can only see those properties in the picture for a form in 2007 and not a control?

[Micron]

Picture property OnOpen works fine for me.
ControlSource is for bound fields. Modifying the displayed picture (which is what starting with a default suggests will happen) has to mean the control is not bound IMO.
I have to agree with Welshgasman - why isn't the 'default' just set as the picture path (linked) in design view?

[GraeagleBill]

Not exactly sure what you're suggesting, as there isn't any ControlSource property revealed with "Me.imgFormImage."

[Micron]

Yes, there is. Data tab.

[GraeagleBill]

I have to agree with Welshgasman - why isn't the 'default' just set as the picture path (linked) in design view?

Only because the app's folder settings are subject to change.

[Welshgasman]

I am just trying it for the form background and am getting the same error

OK, I have just got it to work but as far as I can see I just copied the path which just amended the case?

Private Sub Form_Load()
Dim DefaultImage As String
DefaultImage = "C:\Users\Paul\Pictures\Driving Licence.jpg"
Me.Picture = DefaultImage
End Sub

Picture was Dirty boilersuits.jpg

[GraeagleBill]

Yes, I saw that but the property is not included in the list if one wants to set it in code.

[GraeagleBill]

Try an image control on the form like I have and see if that fails as well.

[Welshgasman]

I now have it working with the picture property, so confused now as to why you cannot?