Results 1 to 6 of 6
  1. #1
    tgall is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2015
    Location
    na
    Posts
    38

    Long Text/Memo field -- Make Border Visible

    How can I make the border appear around a Long Text/Memo field in an Access report?


    I set Border Style = Solid and Can Grow = Yes, but there's no border.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Make sure BorderColor has color and not No Color.

    Those settings work for me.

    I also change BorderWidth to 1 pt or greater - some printers don't deal with Hairline well.
    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.

  3. #3
    tgall is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2015
    Location
    na
    Posts
    38
    Moderator, many thanks for your prompt response.
    I do have a color setting for the border (#C8C8C8).
    The other fields have the same border color and they appear in the printed report.

    I read your reply as saying that you have a Long Text/Memo field in a report
    and that the border appears. In my application the border appears in forms,
    but not in reports.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Yes, textbox is bound to Memo field.

    Try creating another form with textbox bound to Memo field - same issue?

    If you want to provide db for analysis, follow instructions at bottom of my post.
    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
    tgall is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2015
    Location
    na
    Posts
    38
    Figured out what's going on -- another annoying Microsoft nuance.
    For long text/memo fields in reports, even though the Border Style property is set to Solid,
    if there's no data, the box does not appear. If there's data, the box appears.

    For short text borders, the box appears whether or not there's data.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    If by 'no data' you mean the field is Null and you still want the border to show, then maybe use an expression that replaces Null with empty string or maybe even a space. Such as: Nz([fieldname],"")
    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.

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

Similar Threads

  1. Long text or memo box filtering
    By data808 in forum Access
    Replies: 5
    Last Post: 02-12-2015, 04:55 PM
  2. Howto make a field not visible by event?
    By Lycanthrop in forum Reports
    Replies: 4
    Last Post: 09-04-2014, 10:29 AM
  3. Is it possible to make 'long text' longer?
    By rgrstvr in forum Access
    Replies: 1
    Last Post: 07-04-2014, 06:37 PM
  4. Replies: 3
    Last Post: 03-11-2014, 09:32 AM
  5. Replies: 5
    Last Post: 06-19-2012, 10:46 AM

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