Results 1 to 8 of 8
  1. #1
    onlylonely is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    110

    Need help - Wrap Text in Subform

    Hi All,

    I'm having issue on wrap text in subform.
    Appreciate if you could help on this.



    Click image for larger version. 

Name:	access2.JPG 
Views:	18 
Size:	34.1 KB 
ID:	30040

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    More info required.
    What is the issue?
    What are you trying to do--in simple, plain English?

  3. #3
    onlylonely is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    110
    Quote Originally Posted by orange View Post
    More info required.
    What is the issue?
    What are you trying to do--in simple, plain English?
    Hi Orange,

    In the subform on "Issues" column, we are not able to read the full sentences.
    Is there any method to wrap text so that we are able to read the full comment in the issues column?

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    What are some of the values in the Issues? Do all records have values?
    What is the record source of the form and subform?

    Can you show us some code? or post a copy of the database?

  5. #5
    onlylonely is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    110
    Quote Originally Posted by orange View Post
    What are some of the values in the Issues? Do all records have values?
    What is the record source of the form and subform?

    Can you show us some code? or post a copy of the database?
    Hi Orange,

    Thanks for your prompt reply.
    I wish the form become photo below

    Click image for larger version. 

Name:	access3.JPG 
Views:	16 
Size:	32.0 KB 
ID:	30051

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    Put your cursor on the area where I have the red line and drag it down. That will make the display area for each record taller.Click image for larger version. 

Name:	Issues.png 
Views:	17 
Size:	90.6 KB 
ID:	30052

  7. #7
    onlylonely is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    110
    Quote Originally Posted by orange View Post
    Put your cursor on the area where I have the red line and drag it down. That will make the display area for each record taller.Click image for larger version. 

Name:	Issues.png 
Views:	17 
Size:	90.6 KB 
ID:	30052
    Hi Orange,

    This is what i did. Is there any alternative way that the column can adjust itself ?

  8. #8
    Join Date
    Apr 2017
    Posts
    1,679
    No. There isn't.

    In continuous form, for every column displayed is a single control, image of which is displayed repeatedly for every row displayed. You set height for this control, not for every it's image separately.

    You can consider using Memo field type instead Text for Issues (used it some 15 years ago ). User can't see anything useful at all in control when scrolling, but when clicking on it, the full text is displayed in pop-up window.
    (With Memo field, memo text is stored in separate specific table, and in Memo field the link to entry in this memo table is stored)

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

Similar Threads

  1. How do I wrap text in label
    By alemg99 in forum Forms
    Replies: 4
    Last Post: 11-14-2016, 11:24 PM
  2. Wrap Text in report
    By waqas in forum Reports
    Replies: 1
    Last Post: 06-27-2012, 09:31 AM
  3. Wrap text conditionally
    By devcon in forum Reports
    Replies: 6
    Last Post: 06-12-2012, 12:32 AM
  4. Can you wrap text in a Combo Box ?
    By softspoken in forum Forms
    Replies: 5
    Last Post: 03-21-2010, 05:32 AM
  5. wrap text
    By kamolrat in forum Reports
    Replies: 1
    Last Post: 11-17-2009, 01:36 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