Search results

Will try them all. Much appreciated!!

So, using your example, I can't combine them into one statement? =IIf([Mdid] = "ABC123", "\\Reportbackgrounds\ABCreport1.png", Null) =IIf([Mdid] = "DEF123", "\\Reportbackgrounds\ABCreport2.png", Null) =IIf([Mdid] = "GHI123", "\\Reportbackgrounds\ABCreport3.png", Null)

No, these are master customers using the same ID numbers several times. So, it will only be a few with unique backgrounds.

No, we have many customers, only 8 or so have a unique background image on their report. Otherwise, it will use our standard background image.

Got it. No, Mdid is not part of the image name. Mdid is an ID of customers that would have a unique image. Probably about 8 different possibilies otherwise the default image. So, if you could show me an example using three different Mdid values. Thanks.

Yes, that worked. How can I add multiple IF's? If "DEF123" = another image path, etc... Also, if it does not meet any of them, then some default path. Thanks!!!

Can you show me an example of an IF statement using my info?

Are you saying I can put my IF statement in the image ControlSource property?

I'm using an image and the source is an unbound field with the path of the image file. And i have an IF statement that fills in that image path based on value from another field.

I've tried to put the code every where, no luck.

Thanks for the explanation. The control is in the detail area.

But my code works in a command button. What is different about what you are suggesting?

8 different possible images

Both Report View and Print Preview are doing the same. Nothing.

Sorry, it is on Load

I have a report that has a graphic field which based on a value in an unbound field. The code works. But when I put that code on open of the report, no value get put in the unbound field. If I put that same code in a command button, it works fine. So, I'm guessing some kind of time issue...

Do you know of any example db's out there?

I have a report with a command button that creates a pdf and sends it to a specific folder. Is there a way to be able to choose where the pdf goes instead? Maybe a drop down with different locations? Thanks.

Got it! Thanks.

I think I got it working the way I want now. Thanks to all!. How would I write the following? Test: DCount("*","Query2","Field1>0.5 and <=1") I'm trying to return a records that are greater than 0.5 and less than or equal to 1. I used the above but get an error?