Always limited by this!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there, I have been doing allot of nice things with Access, however once in
a while comes along a LIMITATION! or atleast I believe it is!

Well here it is,

I have a check box and an unbound object frame which contains a little
picture, all on a continuous form. What I simply would want to do, is in one
instance as I open the form, every record weather the checkboxe's value is
True or false, the unbound's visible property should be set or reset
respectively. (NOTE*** This should happen on all records, I didn't even click
anywhere yet !!!!)

So basically, if my checkbox is true the picture object should show, however
if in my next record the checkboxe's value is false then that picture object
should not show. All this should happen on the form's open instance and
without any user interaction.

If conditional formatting would have a visible parameter in it, this would
be a breeze, however it doesn't. I would need any other pointer to a
solution without going through x hours of coding. Any ideas!

Help anyone, apps need these automatic scenarios (Limitations or not)

All help is appreciated
Robert
 
this is not a limitation, it is a learning opportuinty!
Set the visible property on the Current event of your form.
 
You mean putting this in the current event of my form:

If Me.Checkbox = true then
Me.UnboundPicture.Visible = true
Else
Me.UnboundPicture.Visible = False
EndIF

If this is so, I still have to click on the current record of the form, and
besides this would make all the Pictures show or not show.

Come again
Robert
 
Robby said:
You mean putting this in the current event of my form:

If Me.Checkbox = true then
Me.UnboundPicture.Visible = true
Else
Me.UnboundPicture.Visible = False
EndIF

If this is so, I still have to click on the current record of the
form, and besides this would make all the Pictures show or not show.
Click to expand...

You cannot per-row hide/show an object in a continuous form. My
understanding is that with conditional formatting you can have this sort of
control over things like color or enabled/disabled, but not for Visible
True/False.
 
sorry, I missed the continuous form part. I don't use continuous forms, so I
am not sure how to do this.
 
If the picture is the same for all record, then a possible solution would be
to use a bound object frame, set the picture in a separate table with two
records with Id of True and False and join to it in a query on the
underlying value of the check box.

However, don't forget that even simple and little images will quickly draw a
lot of memory when used on an Access' continuous form.
 
Back
Top