Image control - continuous view Form - setting visible or not visible

[Ruegen]

Hi Ruegen,

Fascinating sort of task this, and I have got there, I think !!

The command 'CustomPicture: iif(Form_FrmMyTest![B Side Title Comment]=true,"",[Image244])'. was failing. First I thought because
B Side Title Comment is also a custom field. But then I figured that is part of the underlying query for the Form and should be based on the Table.

So I changed it and running up the query shows Custom Picture field has a filespec to a bmp when my Yes/No field is ticked, and is empty where it's false.

Is that about right so far?

In my Form I have an image control and it's control source is CustomPicture. And Viola! my graphic shows where and when it should

But there's a But! I didn't add requery or anything else (yet) and that might be part of it... but it is too slow loading the image. It's pretty small (under 2k)
but could I try and embed it in the database to see if it would it be faster. there's about 18000 rows or records in the Form.

A zillion thanks for sticking with me over this!

I thought Form_FrmMyTest![B Side Title Comment]



was the checkbox on the form. Yes it will take time to calculate the CustomPicture field (expression because that is what it is) as it needs to look at [B Side Title Comment] for every record. If that's the case then every record is evaluating whether or not to show the image. 18000 rows is 18000 records.

When a record evaluates quickly the quicker it can calculate the faster the form will load

so if [B Side Title Comment] is a string rather than a true or false (or a 1/0 or integer) then it will take more time to load.

[Ruegen]

Also I'd still recommend having the image visibility property set to false rather than making the record change.

i.e.
if me.CheckBoxName= true then
me.ImageControl.visible = false
else
me.ImageControl.visible = true
end if

that way you don't have to evaluate 18000 records and you are just 'hiding' the OLE (?) control