G Guest Jul 19, 2005 #1 How do you change the control souce for a text box using VBA Code on a report. It seems to be different to that of a form. Thanks
How do you change the control souce for a text box using VBA Code on a report. It seems to be different to that of a form. Thanks
R Rick Brandt Jul 19, 2005 #2 Ian said: How do you change the control souce for a text box using VBA Code on a report. It seems to be different to that of a form. Thanks Click to expand... You can use a TextBox with NO ControlSource and then set the Value in code in most any event. If you actually need to change the ControlSource you can only do that in the report's Open event.
Ian said: How do you change the control souce for a text box using VBA Code on a report. It seems to be different to that of a form. Thanks Click to expand... You can use a TextBox with NO ControlSource and then set the Value in code in most any event. If you actually need to change the ControlSource you can only do that in the report's Open event.