Continuous Form Visible Controls

[CadMonkey]

Hi,

This is an intriguing one- and never thouroughly solved on this forum? I have a continuous form with records PK- [item_ID]. when this [item_ID] = "hd" it needs to make visible a yes/no control: [new] .....

BUT....

just on that one record on the continuos form, not on all of them!

I can make the control visible on this event on all the records- but I've heard it is impossible for access to allow this functionality?

I believe in Access!! Can you keep my hope alive??

All the best

S

 

[namliam]

In a97 yes quite impossible, maybe with a lot of doing it may be possible but... a lot off hassle

In A2K and above one has the conditional formating you can use to get what you want...

Regards

 

[CadMonkey]

In a97 yes quite impossible, maybe with a lot of doing it may be possible but... a lot off hassle

In A2K and above one has the conditional formating you can use to get what you want...

Regards

Thankyou, but can you conditionally format on a form? The option seems to be greyed out to me... I'm using Access 2k though...

Regards

 

[___]

The option seems to be greyed out to me...

You need to select the control in design view to conditionally format it.

HTH

 

[CadMonkey]

You need to select the control in design view to conditionally format it.

HTH

I do believe you can't conditionally format a yes/no checkbox, because I still can't use this feature.

I was wandering if a VBA solution is possible- it just seems very tricky thing to do.

 

[Oldsoftboss]

You could always draw a solid box over the chk box and switch it's visible/not visible property.

Dave

 

[Rich]

Form_Current
Me.MyCmdBut.Visible = Me.MyControl="hd"
End Sub

 

[CadMonkey]

Thanks for all your help people.

I've ended up implementing Leo's solution, which functions well. The only snag is you can still see the control on every instance of the continuous form when you are on an "hd" item. Of course if you try and click the checkbox on a non-hd item .... well you can't because it dissapears. So it functions really well, thankyou!

It would be really good if I could hide the control for all forms showing a non-"hd" item- but I think this is beyond the Access capability...

Once again, many thanks!

Regards

Hairy Monkey