Is there a way to format a report through VBA? I have a report based on a daily scheduled event. Some days this event does not happen (nor does it need to), but I still need to have it documented. I want to have a hidden control on the report be made visible (this I have the code written for and it works) and moved/resized before it prints. I have the controls on the report set to create a list if data exists, but by doing this, my hidden control is out of position from where it should be printed. Any ideas?