How to reference report control for Picture Property of Image
Posted on 2008-10-13
I have a report which, through a query, makes available a field called PictureFile. I want to select an image by inserting that field name in the Picture Property of the Image control which will display that picture. If I enter the bare name - PictureFile -, I get an error that says that file "PictureFile" cannot be opened. Same if I use quotes, same if enclosed in brackets, same if brackets inside quotes.
What syntax do I use in the Picture property of an Image control to tell it to use the TEXT represented by a control on the report or on the original table, rather than the text of the control or field?
I need to do this on a report that reads many records, each of which has a different picture associated.
If someone can tell me what event changes for each new record, I could do it in VBA code.