Avatar of Nikolay DMITRIEV
Nikolay DMITRIEV
Flag for Switzerland 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?
Microsoft Access

Avatar of undefined
Last Comment
Ryan Chong

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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.
Your help has saved me hundreds of hours of internet surfing.
fblack61
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