[AccessD] Need a Trick for conditional formatting

[Darren - Active Billing]

Hey Rocky

it is possible to make a Command Button visible or not visible per row on a continuous form, but not much else.

Add a button to the continuous form called "cmdButton"

Assume your Check Box is called "chkBox"

Add this to the Detail_Paint of the ContForm

Private Sub Detail_Paint()
   Me.cmdButton.Transparent = Me.chkBox
End Sub

-------------------------------------------------
> On 21 Sep 2023, at 2:21 am, Rocky Smolin <rockysmolin2 at gmail.com> wrote:
> 
> I considered that ploy, having used to to advantage on single forms. But
> this is a continuous form, so I thought to use conditional formatting which
> would have worked except...Problem here is that in Access 2010 (which I
> still develop in to avoid reference conflicts when developing in a later
> version than my client) conditional formatting (which I need to use because
> it's a continuous form) does not provide a visible/invisible option.
> Although I think later versions of Access do.
> 
> Tks
> 
> r
> 
> On Tue, Sep 19, 2023 at 6:47 PM Paul Wolstenholme <
> Paul.W at industrialcontrol.co.nz> wrote:
> 
>> They would disappear if a text box became visible in front of them
>> (especially so if the text box background matched the section background).
>> Should the control become selected it reappears - so think about the tab
>> stop settings.
>> 
>> Paul
>> 
>> On Wed, 20 Sept 2023 at 12:10, Rocky Smolin <rockysmolin2 at gmail.com>
>> wrote:
>> 
>>> 
>>> I have a continuous form with a text box.  I use conditional formatting
>> to
>>> set the back color of the text box based on the value of another field
>>> (True/False)  bound to the form in another text box. Works great.
>>> 
>>> To the left of that text box there are two check boxes, a text box and a
>>> combo box. If the True/False field is true the client also wants those
>> four
>>> controls to disappear.
>>> 
>>> Any ideas?
>>> 
>>> MTIA
>>> 
>>> Rocky
>>> 
>>> 
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> https://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com