[AccessD] conditional formatting

[Rocky Smolin]

Conditional formatting is awesome! That expression field is quite flexible.
Almost any kind of sql statement, nested IIFs, etc. The enable/disable
feature is quite useful as well.

r

On Sun, Jan 28, 2024 at 11:20 AM John Colby <jwcolby at gmail.com> wrote:

> thanks
>
>
> On Sun, Jan 28, 2024 at 2:07 PM Ryan W <wrwehler at gmail.com> wrote:
>
> > Use the expression setting and the expression isull(field) = true
> >
> >
> > Sent from my iPhone
> >
> > > On Jan 28, 2024, at 12:39 PM, John Colby <jwcolby at gmail.com> wrote:
> > >
> > > I have never used conditional formatting.  I need to set the back
> color
> > of
> > > a text box zip field to yellow
> > > if there is nothing in the field.  The only things I see are LT, GT EQ
> > > etc.  So how does one set a format if there is no value at all?
> > > --
> > > John W. Colby
> > > Colby Consulting
> > > --
> > > 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
> >
>
>
> --
> John W. Colby
> Colby Consulting
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>