Conditional Formatting to Make Visible?

[cstuart79]

Stupid question, but is conditional formatting limited to all color/font changes or can it be used on a control to make textbox visible/invisible?

 

[dhookom]

You can't make a control invisible but you might get close by setting the font to the same as the background color.

Duane
Hook'D on Access
MS Access MVP

 

[cstuart79]

i want to be able to toggle between a command button and a textbox based upon the value of a checkbox; therefore, changing command button or textbox to color of background will not allow the other to show through (trying to conserve real estate by having them occupy the same space). was hoping that i could set color of either the command button or textbox to "transparent" or "visible/invisible".....any clever ideas for how to accomplish this?

 

[dhookom]

No ideas...

Duane
Hook'D on Access
MS Access MVP

 

[randy700]

How about something like this?

Private Sub CheckboxName_Click()
    Me.TextboxName.Visible = Me.CheckboxName
    Me.TextboxName.Enabled = Me.CheckboxName
    Me.ButtonName.Visible = Not Me.CheckboxName
    Me.ButtonName.Enabled = Not Me.CheckboxName
End Sub

Randy

 

[dhookom]

I assumed that cstuart79 is referring to a continuous form although he didn't state this. This is based on his initial question regarding "conditional formatting" and his later statement "trying to conserve real estate".

Code that changes the format of a control will change it for every instance of the control on the continuous form.

Duane
Hook'D on Access
MS Access MVP

 

[cstuart79]

i am referring to a continuous form....hence the dilemma

 

[jamaarneen]

This is a challenging question.

I don't think that there really is such a thing "no solution".

So let's not give up. let's hope - and wait - for an interesting solution from one of the more experienced members in here.

 

[MajP]

In this case, as described, I am betting there is no solution.

If you really absolutely had to do this, then make the form unbound. Create each row and then you can control the different controls on each row. You would then have to fill the records through code, and hide/show unused rows. That is a lot of work to save some space.

 

[BDCarrillo]

Make both the text box and command button invisible and use vba in the forms "OnCurrent" event to set the visible/enabled properties based on the checkbox. It'll show the appropriate item when you click (or use a navigation control to go the next/prev) on a record you want to work with, but you'll see it change on every record.

Worked on a small demo for me, but its far from ideal.

Alternate: Set your command button code on the "OnClick" for the text box. Run an IF to verify the value of the checkbox. Make your text box default value the name of your command button.

 

[MajP]

BDCarillo. The OP is using a continuous form. Your solution is for a single form view, and will not work in continuous view as has been previously discussed.