Individualized image visiblilty in continuus form?

[plh]

Hi,
What I want to do is select the visibility of one of three images on a
continuous form based on the value of one of the text boxes, that is:

(Pseudo-code
If text box value less than 100 then
Image1 is visible
Image2 is not visible
Image3 is not visible
If text box value between 100 and 200 then
Image1 is not visible
Image2 is visible
Image3 is not visible
If text box value between more than 200 then
Image1 is not visible
Image2 is not visible
Image3 is visible

Right I have this set up but the visibility changes on all rows simultaneously.
Is there a way around this?
Thank You,
-plh

 

[Albert D. Kallal]

You have to use condifintal formatting here, and some type of color.

I certainly have a lot of continues forms where I set the controls enabled
property on/off. While this actually makes all instances of the control go
disabled, I actually find this works quite well. I mean, when you move
to the next row, those columns that you enable, or disable can then
be set. So, you could set the controls visible property as you move
the cursor up/down through the

In fact, I actually PREFER the above behavior, as then during
data entry it is VERY easy to see that the column in question
is enabled.

In place of a VERY HARD TO READ checkerboard pattern of enabled, and
disabled boxes,, you get a very nice enable/display view as I move the
cursor up /down.

I have uploaded a gif animation of me navigating in a form, both of the two
screen shots will give you an idea of how this looks.

http://www.members.shaw.ca/AlbertKallal/HideColumn/index.htm

In both of the sample screens in the above, the animation shows that
actually disabling the column is not so bad...

 

[plh]

Thank you for that but I really want to have it work the way I originally said.
This is a tool set up information sheet for a machine tool. I want to have three
different pictures for three different tool orientations. So you would see the
continuous list, with the gifs showing the listed tool in one of the three
different orientations. The gifs would be piled directly on top of one another,
the visibility determining which would show, as in my original message as shown
below. Is this possible and if so can you give me some pointers as to the code
needed to do it? I have used the conditional formatting before but I don't think
it can turn tings on and off like that.
Thank You,
-plh

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples. You would use the flex grid instead of the
Continuous form and you can display images in a flex grid cell, you
could easily change the image depending on the other parameters.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

HTH

Peter Hibbs.