[AccessD] Conditional Formatting

Jim Dettman jimdettman at verizon.net
Fri May 7 12:15:51 CDT 2021


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



More information about the AccessD mailing list