Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jun 2003
    Location
    New York, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    grow/shrink (2k)

    Greetings All!
    So, I'm designing a report and I've successfully used the Grow/Shrink property settings for some memo fields. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    I have a section that shows various text fields in the same line, pulled via query. Is there a way to Grow/Shrink horizontally? I don't like the extra spacing that occurs between txt fields.

    Otherwise, would my best solution be an unbound txt box w/ the various fields and formats? I'm thinking like the way I put a First and Last Name together:
    =[consumer_firstname] & " " & [consumer_lastname]

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: grow/shrink (2k)

    There is no "horizontal CanShrink" property. As you suggest, a good way to get around it is to use an expression that concatenates the contents of several fields. Other solutions would probably involve VBA code.

  3. #3
    Lounger
    Join Date
    Jun 2003
    Location
    New York, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: grow/shrink (2k)

    Perhaps I'll tackle a VBA solution another day. For now, I'll stick with the unbound txt box.

    Thanks Hans!

Posting Permissions

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