Check For Empty Image Of Image Control In Continous Form

[akapag22]

Hi friends,




I am using a continous form and using an image control in it.
For records which have jpg file, the image loads up good. But for records which have .xlsx the dont show up.
Hence i would like to put a text "excel file" on the image control by checking if its xlsx extension.


How can i do it for all records in continous form? Thank u

[ranman256]

you cant on continous forms.
The ONLY way would be to run an update query to fill the image field with an excel X, where instr([file],".xls") > 0

in continuous forms, ALL records must look at the same field. no if then

[ItsMe]

Maybe you could create an image that is the text you wish to display. Give the image an unique name. Then, create an alias in a query and bind your form to the query. In your alias, you can employ an Inline If Statement.

something like ...
If [OriginalField] LIKE *.xls then
[AlaisField] = "myPicture.jpg"
Else
[AlaisField] = [OriginalField]

[June7]

Are these images in a table or external?

Image control ControlSource property can have an IIf() expression.