Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002

    Unanswered: Do not leave space on blank records


    In Ms Access 2000, is there any way not to show a blank space in detail part?

    For Example I have a group heading called Stock and if there is no history for stock under detail I do not want a blank gap there instead move to the next record. The gap is there is because if there was data for the record it would come out, but if there is no record I do not want to show a blank space.

    Is there any way to get rid text boxes which are blank so the report is more compact

    Thank you in advance

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    place some code in the reports detail "on format" event to cancel printing if any of the required fields is blank then cancel printing

    its going to be something like
    if mycolumn="" then cancel=true
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Yes... or if you don't want to show the space only if ALL of the fields are blank, you can set all the control's properties in the detail section to have Can Shrink to Yes. Do the same for the Detail section itself.
    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