[AccessD] Conditional Formatting

[Jim Dettman]

Rocky,

 Glad to hear you got it resolved.

 Have a great weekend!

Jim.

-----Original Message-----
From: AccessD On Behalf Of Rocky Smolin
Sent: Friday, May 7, 2021 1:47 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Conditional Formatting

Got it! In the process of going through the steps to document for you, I
tried putting the requery call in the modal/popup form and walla!  It
worked.

The conditional rule is checking the value of another text box on the form
that has the value of the number of comments (in a child table) for the
record that has the focus.  The box is a field in the query that is the
recordsource for the form and is invisible.  But I've made it visible for
debug purposes to confirm that it has either a 0 (no comment record) or 1
(has a comment record).  The condition
is: [CountOffldTenantLeaseStepID]<>0.  When I delete the comment, and close
the form, the number of comments stays at 1.  I thought the code would stop
executing while the modal form was open but it didn't. Sp my requery in the
calling form was being executed before the modal form closed.

So moving the Requery of the calling form to the modal form solved it!

Thank you.

r

TIA

rocky


On Fri, May 7, 2021 at 10:16 AM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

> Rocky,
>
>  What is your conditional check looking for?  What exactly is the check?
>
> Jim.
>
> -----Original Message-----
> From: AccessD On Behalf Of Rocky Smolin
> Sent: Friday, May 7, 2021 11:29 AM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>; Off Topic <dba-ot at databaseadvisors.com>
> Subject: [AccessD] Conditional Formatting
>
> Dear list(s)
>
> I have a text box with an asterisk in it on a continuous form.  When the
> user clicks the box a modal/ pop-up form opens and the user can enter a
> comment in a memo field which is linked to the parent recordset by PK/FK.
>
> I have conditional formatting set so that if there is a comment for that
> particular record the backcolor of the asterisk box turns red - if no
> record the backcolor is white.  This is so the user can see which records
> on the form have comments attached to them.
>
> This works fine when I open the parent form - the asterisk box for all the
> records which have comments are backgrounded red, those without comments
> are white.
>
> The problem is that when I add a comment to a record that didn't have one
> the asterisk box does not turn red when the modal/popup form closes.  And
> when I delete the comment so that the record has no comment, the
background
> color of the asterisk box does not turn from red to white.
>
> Exiting the form and re-entering it again show the right conditions for
> each record on the form.
>
> So the conditional formatting is not being triggered except when the form
> opens.  I have tried requery, refresh, and repaint but no cigar.
>
> *Does anyone know how to refresh the conditional formatting of fields on a
> form while it's open?*
>
> MTIA
>
> Rockty
> --
> 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
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com