Results 1 to 2 of 2

Thread: Format a report

  1. #1
    Join Date
    Nov 2002
    Posts
    49

    Unanswered: Format a report

    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?

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    This works for me.

    Size your text box in design view as short as you possibly can. Set the Cangrow property to True. If data prints in the text box the box grows to accomodate, else it remains a thin line of nothing.

    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •