Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Earth | North America | United States | California | Long Beach
    Posts
    62

    Unanswered: Format controls based on position in report

    Is there a way to select controls based on their location within a report using vba?

    Specifically, I am looking to hide the second half of a report based on the criteria of the report select screen.

    The report is already built and I would rather not build a subreport for the second half of the page.

    So, any help with selecting controls based on position (or any other theories) is greatly appreciated.

    Many thanks,
    Jack

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    Look up RptSmp00.mdb in MS Knowledge base. It is a sample DB with about 20 different sample reports. If i remember right I think one of those will give you a step in the right direction.


    S-

  3. #3
    Join Date
    Jul 2003
    Location
    Earth | North America | United States | California | Long Beach
    Posts
    62
    Thank you very much.

    Some very cool examples here.

    Thanks for the lead.

    Jack

Posting Permissions

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