Hide or display button on Continuous Form depending on value in text box.

[recyan]

Have a Continuous Form with 2 bound Text Boxes ( txtID & txtStatus ) & an unbound button.


If the Text box txtStatus has value "Pending" in it, I want the button "View Details" to be Visible, else want to hide the button.

Request some pointers.

Thanks

[ItsMe]

When you use a continuous form, VBA will fire for the current record. So, if you click on record number three, the VBA will evaluate the data in that record and will not consider data in records one and two. The result will be applied to all visible records. This is how unbound controls behave in continuous forms.

The closest thing to a solution would be conditional formatting. However, I do not believe this will benefit you and your button control.

You are most likely going to have to use the form's Header and or Footer for your Command Controls. Another option is to use an unbound Main form to simulate a Header/Footer.

[recyan]

@ItsMe,
Was hoping against hope, that it could be done.
And Thanks for the pointers to other possible options.

Thanks