For example, you can set conditional formatting so that if an employee's salary exceeds £100,000 the field's background turns red. Or you can set formatting so that text in the City field is green and italic if a customer resides in London. Forms and reports. The tables in this section provide examples of expressions that calculate a value in a control located on a form or report. To create a calculated control, you enter an expression in the ControlSource property of the control, instead of in a table field or query. Note You can also use expressions in a form or report when you Highlight data with conditional formatting.
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 |
|