Results 1 to 2 of 2

Thread: Report format

  1. #1
    TonyM
    Guest

    Report format

    I am doing a report in Access97 and have a list of database locations to display. Because the database can be in up to 8 locations there are fields to display the location. In the report they are 8 controls are placed in the detail field in a tabular arrangement. If there is only one location for the database there is a lot of space between each new database location. Is there a way to close up the space if the control doesnot contain any data?
    Hope this makes sense to anyone?

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report format

    You might try the CanShrink property of the sometimes-empty textboxes. OR you could concatenate your 8 fields into one textbox like: [Field1] & " " & [Field2] & " " ....and so on.

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

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