Microsoft Access Conditional Formatting Examples Sentences
It sounds like the subform isn't refreshing after an update in the main form. Is this the behavior that you're trying to achieve? It's not clear how you've implemented this; you should be able to requery the subform without affecting your main form (Me.SubForm.Requery). Also, have you tried to requery the control directly? For example, using an AfterUpdate event from the main form, do something like: Me.SubForm!Sales.Requery mi********@gmail.com wrote: >Hello,
I have conditional formatting set up on a subform based on a calculated
value in the underlying query. For instance, if Sales are >$1000, the
query displays 'Yes,' otherwise it displays 'No.' The conditional
formatting is set up to read the 'Yes' or 'No' value and color the text
accordingly.
I have an event in the subform that allows users to update the sales.
It actually runs an update query behind the scenes. What I want to
happen is for the formatting to pick up the value immediately and
change color. I can requery the subform, but that loses my place in the
form. And refresh doesn't seem to trigger the conditional formatting to
check for the values.
Is there any way to refresh conditional formatting on the fly? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200611/1 |
|
Microsoft Access Conditional Formatting Examples Template
Click on your first square 'SV1', then on the menu bar, select ‘Format' then ‘Conditional Formatting' (Microsoft Access 2003 or earlier). For Access 2007 or later you will find the conditional formatting button on the 'Design' ribbon, it is now just called 'Conditional'. The conditional formatting. For example, lets say I have the following fields. The DAYSOPEN field is automatically calculated in the query and is not a stored date. My criteria is that if CAT# is 3, my days open should not exceed 30 but if my CAT# is 1 or 2, my days open should not exceed 60. Find answers to Conditional Formatting of MS Access Cont Form from the expert community at Experts. Example as attached. Microsoft Access.
