Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Report and Double Underline

Status
Not open for further replies.

vbLew

Programmer
Feb 28, 2005
22
US
Hello All:

I have "double underline" problem. I've created a report in access where everything is outlined with a double underline number.
The double underline is shown in the report in access, however, when I export the report to a .rtf file. I no longer get a number that is double underlined. Does anyone know how to solve this?

Thanks!
 
If the underlining is done with lines/boxes in your Access report it will not be exported in RTF format, since these "drawing" objects are not supported in Rich Text Format.

To preserve formatting you need to consider exporting in either Snapshot format (very easy but your users will need Access Snapshot viewer installed to view) or PDF (a little more complex but there are loads of posts in these forum regarding how to do this).

Of course, the downside of both these formats is that they are read-only.

[pc2]
 
Hi
Because of this very problem I sometimes use HTML output from Access, skipping reports altogether - easy to do and loads of formatting. The HTML can then be programmatically loaded into Word, with a template.
 
Thanks you all for your help and replies.
The only solution I have come up with is similiar to
Remou. It looks likes I gonna have to code some vb to programmatically create a word doc (using the word 9.0 object library) and export my data there, so I can manually code the fomatting.
 
Thanks you all for your help and replies.
The only solution I have come up with is similiar to
Remou's. It looks likes I gonna have to code some vb to programmatically create a word doc -using the word 9.0 object library- and export my data there. This way I can manually code the fomatting (the double underline). I was trying to avoid this, but it appears that I can not get around this as long as I use the double underline in my outlines. Thanks again for all your inputs.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top