Display images in continuous form if checkbox checked

[Thomasso]

Hello,



I have this continuous form of orders:



On the right side there are 6 pictures. I want them to show only when certain conditions are met.

The first 3 mean this:
- Ordered from distributor
- In transit to us
- Received from distributor
For these I created Yes/No checkbox in the orders table and the data entry form, looking like this:



The other pictures visibility will be determined by dates.

The data source for my continuous form is a query - showing all placed customer orders. Data entry order is connected directly to table orders.

Can I do this using expression builder or will code be necessary?


Thank you.
Tomas

[ranman256]

Sorry, but on a continuous form, they either ALL show, or NONE show.
There is no: some show, some dont.

Tho, there may be a way to cheat this.
have 2 image fields: 1 to hold the image, and a 'DisplayCopy' to display.
if you want the image to display, update the DisplayCopy = OrigImage.
if not, set the DisplayCopy=null.

THEN it will show on continous forms.

[orange]

Tomas,

Untested, but it might be possible to use conditional formatting to "color code" the conditions rather than images.

There is a post here that shows what can be done with some values and wingding font.

[Thomasso]

Thanks guys.

So I am only able to change background colors etc, no way that my pictures will be shown, correct?

Thanks,
Tomas

[orange]

I haven't found a way based on google.
ranman may have a sample or more details based on his response post #2.

[Thomasso]

Sorry, but on a continuous form, they either ALL show, or NONE show.
There is no: some show, some dont.

Tho, there may be a way to cheat this.
have 2 image fields: 1 to hold the image, and a 'DisplayCopy' to display.
if you want the image to display, update the DisplayCopy = OrigImage.
if not, set the DisplayCopy=null.

THEN it will show on continous forms.

Sorry, I didn't get around to it till now. Thanks for the suggestion, it seems like it could work ..

However, I can't find any information about "DisplayCopy" anywhere. Could you provide me with some elementary VBA structure of how you would approach this?

And if I understand correctly, I should hide the image "holder" field and then display a copy of it, correct?

Thanks,
Tomas