asked on

Conditional Formatting of MS Access Cont Form

Dear Experts,

There is MS Access Continuous Form. Each record contains several small images (pictograms).
I want to make visible pictograms based on the value of hidden numeric field. Something like:
If Me.[Field1]=1 then Me.Image1.Visible= True
Can you please help with syntax?

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Nikolay DMITRIEV

ASKER

Good day,

Thanks for above. The form is continuous. Above works only if the record is selected. I've tried to play with If>Then OnCurrent even already, i.e. looks perfect to to find right syntax in Conditional formatting expression for [field1].

Thanks in advance
merry X-Mas and Happy New Year
Nikolay

Scott McDaniel (EE MVE )

You want them to show individual images for each record? Like Record 1 will show images 2 and 3, and Record 2 will show images 1 and 4? If so, then you've run into a limitation of a continuous or datasheet form.

You could try adding fields to your tables and storing the path to your images in those fields. To "show" an image, you'd include the path, and to hide the image you'd just delete the path. Add image controls to your form, and "bind" those controls to the underlying fields.

I've not done this, so don't know if it would work but in theory it should.

Mark Edwards

Not enough technical info on what you are doing on each record. Solution depends on exactly what you've got and want to do. Can't tell so far.

Ryan Chong

Scott's suggestion above should worked.

do make sure you got these configuration:

For your image control's property:

1. at Format tab, set Picture Type = Linked
2. at Format tab, set Picture = (None)
3. at Data tab, Control Source = Path (your Field that storing the image path)

Ryan Chong

Example as attached.
29167937.accdb