Re: Problems with exporting controls with borders to .rtf

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 12:39:23 -0600

I have used the generic concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You can
insert tabs and carriage return/line feeds so the result formats properly in
a Word text box. The call to Concatenate might look like
Concatenate("SELECT [FirstName] & chr(9) & [HomePhone] FROM tblRegistration
WHERE ClassID=" & [ClassID], Chr(13) & Chr(10) ) 

-- 
Duane Hookom
MS Access MVP
<anonymous@discussions.microsoft.com> wrote in message
news:8ef501c4051b$72145ed0$a401280a@phx.gbl...
> Hi Eric
>
> Thanks for your reply, it's much appreciated. I have mail
> merged to Word from Access before but there is one thing I
> don't know how to do.
>
> With a report, you can use subreports to represent the
> many side of a relationship. A subreport can display any
> number of records from the many side of the relationship
> within the main report, which is the one side of the
> relationship.
>
> In the document I wish to create in Word, I need to have a
> subreport type feature where any number of related records
> can be listed in the main document. Specifically, I need
> to create a document representing a training course, which
> will contain a section listing all booked delegates, of
> which there can be any number. This would be achieved
> using a subreport if I was using an Access report. How is
> it achieved if mail merging to Word?
>
> I hope that you understand what I mean and can help out!
>
> Thanks
>
> David
>
>
>
>
> >-----Original Message-----
> >Hi David,
> >
> >When you export Reports it's known that you lose some
> formatting (Reports
> >really NOT designed for this purpose).  If you are
> needing to edit the
> >Report after it's exported you may want to try exporting
> to PDF format (but
> >you would have to have Adobe Acrobat, not just the
> reader, to edit it).
> >
> >In my opinion your best option would be to create a mail
> merge (you have
> >complete control over the mail merge document).
> >
> >I hope this helps!  If you have additional questions on
> this topic, please
> >respond back to this posting.
> >
> >
> >Regards,
> >
> >Eric Butts
> >Microsoft Access Support
> >
> >"Microsoft Security Announcement: Have you installed the
> patch for
> >Microsoft Security Bulletin MS03-026?  If not Microsoft
> strongly advises
> >you to review the information at the following link
> regarding Microsoft
> >Security Bulletin MS03-026
> ><http://www.microsoft.com/security/security_bulletins/ms03
> -026.asp> and/or
> >to visit Windows Update at
> <http://windowsupdate.microsoft.com/> to install
> >the patch.  Running the SCAN program from the Windows
> Update site will help
> >to insure you are current with all security patches, not
> just MS03-026."
> >
> >
> >
> >--------------------
> >| Thread-Topic: Problems with exporting controls with
> borders to .rtf
> >| thread-index: AcQCwf2vC/ekOTy6RDSXZIkJiri2bA==
> >| X-Tomcat-NG: microsoft.public.access.reports
> >| From: =?Utf-8?B?RGF2aWQgQ2xlYXZl?=
> <anonymous@discussions.microsoft.com>
> >| Subject: Problems with exporting controls with borders
> to .rtf
> >| Date: Fri, 5 Mar 2004 06:56:08 -0800
> >| Lines: 11
> >| Message-ID: <609F1913-4659-449A-9238-
> E072120B9417@microsoft.com>
> >| MIME-Version: 1.0
> >| Content-Type: text/plain;
> >| charset="Utf-8"
> >| Content-Transfer-Encoding: 7bit
> >| X-Newsreader: Microsoft CDO for Windows 2000
> >| Content-Class: urn:content-classes:message
> >| Importance: normal
> >| Priority: normal
> >| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >| Newsgroups: microsoft.public.access.reports
> >| Path: cpmsftngxa06.phx.gbl
> >| Xref: cpmsftngxa06.phx.gbl
> microsoft.public.access.reports:132655
> >| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
> >| X-Tomcat-NG: microsoft.public.access.reports
> >|
> >| Hi all
> >
> >I have a report which has a kind of tabular look created
> using text box and
> >label controls with borders. I would like to be able to
> export this to an
> >editable format such as .rtf, but Access doesn't export
> the borders!
> >
> >Exporting to Snapshot exports the borders just fine, but
> is read-only so no
> >real use to me.
> >
> >Anyone got any advice on this?
> >
> >Thanks
> >
> >David
> >|
> >
> >.
> >