Need to override bound control in report

M

mscertified

I have 2 controls in a report that are bound to columns in a table. Under
certain circumstances I need to load these controls with different data. I
tried to do this in the FORMAT event but get an error saying the 'control
source' cannot be changed after printing has started. How do I do this?
 
F

fredg

I have 2 controls in a report that are bound to columns in a table. Under
certain circumstances I need to load these controls with different data. I
tried to do this in the FORMAT event but get an error saying the 'control
source' cannot be changed after printing has started. How do I do this?
Click to expand...

Use an UNBOUND control:
=IIf([FieldName] = SomeCriteria,"This is the new text",[FieldName])
 
Top