Visible Button

[Guest]

I have a button (say "button1") that is visible on a record line on a
continuous form. I only want "button1" to appear when another control (say
"Check1") on that record line is equal to "G". At all other times I want
"button1" to not be visible.

Can anyone help?

 

[Allen Browne]

You cannot selectively hide a command button on a continuous form (i.e. hide
it on only some rows.)

As a workaround, you could set up a text box to look something like a
button, and then use Conditional Formatting (Format menu in design view) to
make it seem to disappear (e.g. white text on white background.)

If you are using Access 2007, you could also do it with an image control set
up to look like a button, since the image does have a Control Source in the
new version.