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.
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.
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.
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.
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.
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.
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.