Continuous Form command button visibility

[kdbailey]

I'm creating a continuous form in which each record has a command button. The command button is hidden unless specific criteria is met. At this point I want the button to become visible, but only on that record.



The code currently running makes the button visible on all records. Is there a way to make just the button on my current record appear?

[John_G]

I don't think so. Changing the appearance of a command button will change the appearance of all occurrences of the button, and conditional formatting doesn't apply to command buttons. You could make the button (in)visible in the form's On Current event, but again, that would affect all the records, not just the current one.

About all you can do is put a check in the code behind the button to not do anything (or perhaps give a message) if the data doesn't allow it.

[kdbailey]

That's pretty much the response I was expecting. Thanks John_G

[aytee111]

Set the command button to Transparent=yes
Add a field to your record source (e.g. Button:"Command")
Add that field as a text box to your form
Put it behind the command button, unavailable (but visible) to the user
Do conditional formatting for that text box.

[Bulzie]

You could maybe use conditional Formating with a text box can make control source = "Select" and change color or bold but not sure you can make visible/invisible. You can click OnClick on that box even though you won't have the mouse pointer. Other options is to have the button in the header but do what you need based on the record it is on.

[aytee111]

No, you would have to change the font color to be the same as the background, bit difficult when you have alternating colors. Or use the enable rule rather than visible.

Change the mouse pointer for the button to Hyperlink Hand (Cursor on Hover property).

[aytee111]

OK, scrap all of what I said, it doesn't help! (Got it working on my side, then forgot to test it, rookie)