Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Posts
    10

    Unanswered: Report with superimposed text boxes

    I have a problem that I'm not sure can be solved. I have a report (see Report1 attached) which will show both those OnLeave (OnLeaveStartDate, OnLeaveEndDate) and ALSO those Seasonal (SeasonalStartDate, SeasonEndDate).

    The problem is in how to get both types of leave to show on the report with their respective dates. There is one table holding both check boxed fields "On Leave" and "Seasonal" and the database populates the table with the respective starting and end dates OnLeaveStartDate, OnLeaveEndDate, and SeasonalStartDate, SeasonEndDate.

    If I superimpose the "SeasonalStartDate" and "SeasonalEndDate" fields over the top of "OnLeaveStartDate" and "OnLeaveEndDate", the attached report design shows the idea (see ReportResult attachment).

    Namely the attached "ReportResult" shows only the seasonal volunteers and their respective dates. The OnLeave volunteers dates are hidden.

    Of course if I were to NOT superimpose the fields for seasonal over "on leave", (see ReportExp), this leaves a formatting issue - see attached ReportNSuper.

    Any hints as to how to solve either the superimposed textboxed field and or how to reformat the report to have everything nicely fit proportionally?

    All the best,

    Frank
    Attached Thumbnails Attached Thumbnails Report1.bmp   ReportResult.bmp   ReportExp.bmp   ReportNSuper.bmp  

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Was this not dealt with here?

    http://www.dbforums.com/microsoft-ac...ext-boxes.html

    I can think of several other ways around it. Using the Can Grow/Can Shrink properties of the textboxes, using formulas like:

    =IIf(Seasonal = True, SeasonalField, LeaveField)
    Paul

  3. #3
    Join Date
    Jun 2009
    Posts
    10

    Report with superimposed text boxes

    Quote Originally Posted by pbaldy
    Was this not dealt with here?

    http://www.dbforums.com/microsoft-ac...ext-boxes.html

    I can think of several other ways around it. Using the Can Grow/Can Shrink properties of the textboxes, using formulas like:

    =IIf(Seasonal = True, SeasonalField, LeaveField)
    You genious you!

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    lol!


    567890. Stupid limits.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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