[AccessD] Conditional Formatting

[Charlotte Foust]

Timing is everything! ;)
Charlotte Foust
(916) 206-4336


On Fri, May 7, 2021 at 10:47 AM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> 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
>