Rich Text Control - Shortcoming Work Around

[dynamictiger]

Hi All

I am making a fairly complex report in Access 2007. It becomes an Operations and Maintenance Manual and for the most part after a few challenges it is going well.

Anyway I am reluctant to output the report to Word as the overheads involved are high and the amount of coding required opens up too many potential errors.

So far whenever I have needed to tabulate data I have been getting around it using Space and whilst this works okay, I really need to able to insert word tables into this report inside access.

I have never worked this way before and don't even know if it can be done or whether this is a waste of time.

Has anyone tried this before and got any results or better still code example to have a look at?

[ADezii]

Hi All

I am making a fairly complex report in Access 2007. It becomes an Operations and Maintenance Manual and for the most part after a few challenges it is going well.

Anyway I am reluctant to output the report to Word as the overheads involved are high and the amount of coding required opens up too many potential errors.

So far whenever I have needed to tabulate data I have been getting around it using Space and whilst this works okay, I really need to able to insert word tables into this report inside access.

I have never worked this way before and don't even know if it can be done or whether this is a waste of time.

Has anyone tried this before and got any results or better still code example to have a look at?

I really need to able to insert word tables into this report inside access.

Try the following to manually Insert a Word Table into an Access Report:

1. Open the Report in Design Mode and select the appropriate Section into which you will Insert the Word Table.
2. From the Report Design Menu:
   1. Insert
   2. Object
   3. Create from File
   4. Click Browse button and select the Word Document
   5. OK
3. Word Table will be inserted into the Report at the specified Section

[dynamictiger]

Try the following to manually Insert a Word Table into an Access Report:

1. Open the Report in Design Mode and select the appropriate Section into which you will Insert the Word Table.
2. From the Report Design Menu:
   1. Insert
   2. Object
   3. Create from File
   4. Click Browse button and select the Word Document
   5. OK
3. Word Table will be inserted into the Report at the specified Section

Thanks for that suggestion, I know I can paste a table across from a word document, however I need to be able to do this in code. And more specifically I need to be able to create and populate the table in code, inside a rich text control. I also need some other word functions like page break to be available inside the text box control (in an ideal world). My issue with section 6 of the manual is that it is huge and repeatitive and could contain from 10 - 1000 pages of data depending on what project we are talking about.

I have also considered this as a sub report, and this may be the only approach that works, but thought Word tables would be a nice touch in other areas as well.

[ADezii]

Thanks for that suggestion, I know I can paste a table across from a word document, however I need to be able to do this in code. And more specifically I need to be able to create and populate the table in code, inside a rich text control. I also need some other word functions like page break to be available inside the text box control (in an ideal world). My issue with section 6 of the manual is that it is huge and repeatitive and could contain from 10 - 1000 pages of data depending on what project we are talking about.

I have also considered this as a sub report, and this may be the only approach that works, but thought Word tables would be a nice touch in other areas as well.

What you are describing would probably involve complex OLE Automation code in order to manipulate Word pro-grammatically. The Rich Text Box Control is not native to Access and may/may not be Registered on your system, it doesn't seem to function well in an Access environment, also. This would add another layer of complexity to the project at hand. The Sub Report idea may be the better approach.