Results 1 to 5 of 5
  1. #1
    dvgef2 is offline Novice
    Windows 8 Access 2013
    Join Date
    Mar 2013
    Posts
    25

    Text Boxes Grow Horizontally


    Hi everyone, Is it possible to grow a text box horizontally? I know there is a 'Can Grow' property but that seems to only work vertically. I have a report that puts names in the letter and since everyone's name is different lengths...it looks odd. Currently I have a long text box in the sentence and it is set to center the text but again, it looks amateurish and although I am actually below the amateur level, I was hoping I still could make it look a little better. Thanks for your time! Dave

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    There isn't an easy way that I know of to do what you want. However you can concantenate your names so that they appear as one field instead of multiple fields that you want to adjust the width on.

    so let's say you have NAME1 and NAME2 in your long string of text use a TEXT BOX and have something like:

    ="Here is the main text of the final product and I am inserting the names " & name1 & ", " & name2 & " into a larger string so that it looks continuous and there are no ugly spaces left"

  3. #3
    dvgef2 is offline Novice
    Windows 8 Access 2013
    Join Date
    Mar 2013
    Posts
    25
    Thanks for the reply Rpeare, I tried to do this but I must have been doing something wrong because I was getting some error. Anyway, I would think that it would not be hard for a computer to count each character in the name and adjust the sentence accordingly but I guess I expect too much from these machines sometimes. Thanks again for your response! Dave

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Show the expression you attempted.

    Counting characters to calculate a width value is unreliable with proportional fonts. W is much wider than i. Concatenation is the simplest approach.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    As june said you'll only get a reliable width calculation when you use specific fonts. Perhaps work on your concantenation syntax and if you have a problem with that re-post?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 06-04-2014, 10:45 AM
  2. Replies: 3
    Last Post: 02-07-2013, 09:53 PM
  3. text box to grow or shrink horizontally
    By Ray67 in forum Reports
    Replies: 4
    Last Post: 01-29-2013, 07:50 PM
  4. Grow text box on form with focus
    By Karen H in forum Forms
    Replies: 5
    Last Post: 02-25-2011, 12:03 PM
  5. Text box resize horizontally
    By cowboy in forum Reports
    Replies: 1
    Last Post: 06-09-2010, 09:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums