[AccessD] [EXTERNAL] Re: Need a Trick for conditional formatting

Shane Groff shaneg at microsoft.com
Wed Sep 20 11:39:50 CDT 2023

Still not available in current versions of Access.  Seems like a good candidate to put on the feedback portal (https://feedbackportal.microsoft.com/feedback/forum/818e3b49-e61b-ec11-b6e7-0022481f8472)

Also, obligatory reminder that Office 2010 is completely out of support and is no longer receiving security updates. You and your clients should move to a more recent version of Office.


-----Original Message-----
From: AccessD <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com> On Behalf Of Rocky Smolin
Sent: Wednesday, September 20, 2023 9:21 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: [EXTERNAL] Re: [AccessD] Need a Trick for conditional formatting

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.



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://data/
> baseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=05%7C01%7Cshaneg%
> 40microsoft.com%7Cd451c1d74a1145b27ae008dbb9f5aa3d%7C72f988bf86f141af9
> 1ab2d7cd011db47%7C1%7C0%7C638308237025978149%7CUnknown%7CTWFpbGZsb3d8e
> yJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C30
> 00%7C%7C%7C&sdata=JeZYjAbUBa6FlPAPyA5RxGW9bliXb%2BJBaj8mfvnGeA8%3D&res
> erved=0
> Website:
> http://www.d/
> atabaseadvisors.com%2F&data=05%7C01%7Cshaneg%40microsoft.com%7Cd451c1d
> 74a1145b27ae008dbb9f5aa3d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7
> C638308237025978149%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIj
> oiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=eviZwuZ
> zLDv62sDZEaSHZU6zkPYjSjvqPBzGTCyPH1s%3D&reserved=0
AccessD mailing list
AccessD at databaseadvisors.com
Website: http://www.databaseadvisors.com/

More information about the AccessD mailing list