Hlp! Insert Symbol based on Range

[dee]

I am creating a report that includes weight, blood pressure, etc. and have to
show a different picture (or symbol) that indicates Fine, Could be better,
Needs attention, for example.

So, I need a way to look at their result, compare it with normal ranges and
then have the correct picture appear.

Any ideas would be greatly appreciated!

 

[Ken Snell \(MVP\)]

You likely could use an expression in the Picture property of an Image
control in the repor; for examplet:

=IIf([FieldName] Between "One Value" And "Another Value",
"C:\FolderName\GoodPicture.bmp", IIf([FieldName] < "One Value"",
"C:\FolderName\TooLowPicture.bmp", "C:\FolderName\TooHighPicture.bmp"))

 

[dee]

Thanks for your reply!

I will try that. Do you think I can use a character value instead of an
image file?

In Excel, I would do something like this:
=IF(B1>=12,CHAR(74),CHAR(75))


Thanks!
--
Thanks!

Dee

You likely could use an expression in the Picture property of an Image
control in the repor; for examplet:

=IIf([FieldName] Between "One Value" And "Another Value",
"C:\FolderName\GoodPicture.bmp", IIf([FieldName] < "One Value"",
"C:\FolderName\TooLowPicture.bmp", "C:\FolderName\TooHighPicture.bmp"))

 

[Jeff Boyce]

Already answered in response to your other post in another newsgroup.

When you post the same question in multiple newsgroups, you have no way to
tell that it has (already) been answered in one of those. Plus, the folks
who volunteer their time here end up duplicating efforts by answering the
same question multiple times.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Ken Snell \(MVP\)]

Not if you're using an Image control. If you're using a Textbox control,
then you can put the expression (with Chr references) in the Control Source
property of the textbox.

--

Ken Snell
<MS ACCESS MVP>

Thanks for your reply!

I will try that. Do you think I can use a character value instead of an
image file?

In Excel, I would do something like this:
=IF(B1>=12,CHAR(74),CHAR(75))


Thanks!
--
Thanks!

Dee

You likely could use an expression in the Picture property of an Image
control in the repor; for examplet:

=IIf([FieldName] Between "One Value" And "Another Value",
"C:\FolderName\GoodPicture.bmp", IIf([FieldName] < "One Value"",
"C:\FolderName\TooLowPicture.bmp", "C:\FolderName\TooHighPicture.bmp"))

--

Ken Snell
<MS ACCESS MVP>

I am creating a report that includes weight, blood pressure, etc. and
have
to
show a different picture (or symbol) that indicates Fine, Could be
better,
Needs attention, for example.

So, I need a way to look at their result, compare it with normal ranges
and
then have the correct picture appear.

Any ideas would be greatly appreciated!

 

[dee]

Hi Jeff,

If you read my post in the other newsgroup, (my second one), you will see
that I apologized for posting in the wrong area of this newsgroup. I had
posted a query question and forgot to change to the reports part to post this
question.

I absolutely appreciate all of the help I have received through these
newsgroups and would never intentionally post twice.

Again, my apologies. I will check for your answer - thanks so much!
--
Thanks!

Dee

Already answered in response to your other post in another newsgroup.

When you post the same question in multiple newsgroups, you have no way to
tell that it has (already) been answered in one of those. Plus, the folks
who volunteer their time here end up duplicating efforts by answering the
same question multiple times.

Regards

Jeff Boyce
Microsoft Office/Access MVP