Justification of Text
- Thread starter cihow81
- Start date
- Local time
- Today, 14:52
- Joined
- Feb 28, 2001
- Messages
- 30,558
For a text field, you can set the property to right justify, left justify, or center justify. However, the FOURTH method (full justification with even margins on both sides) is a word-processing function. Access is not a word processor.
joining of access to words
Hi,
i understand that publishing a report through access, the paragraphs could not be fully justified... Are there any ways where i can get about this problem... i need to generate reports using the existing datas inside the access database... is is possible for me to write some macros to join word to access, so that when i print report, i could print straight to a word file n my words could be fully justified??? , or could i replace the report in access wit word??? any help is welcome... thanks... are there any suggestions tat i could get around this problem...???
Hi,
i understand that publishing a report through access, the paragraphs could not be fully justified... Are there any ways where i can get about this problem... i need to generate reports using the existing datas inside the access database... is is possible for me to write some macros to join word to access, so that when i print report, i could print straight to a word file n my words could be fully justified??? , or could i replace the report in access wit word??? any help is welcome... thanks... are there any suggestions tat i could get around this problem...???
- Local time
- Today, 14:52
- Joined
- Feb 28, 2001
- Messages
- 30,558
What it SOUNDS like you want can be done via mailmerge, perhaps. You need to look up MailMerge in Word AND in Access.
Basically, you set up a template in Word. If that template includes such things as full-justified text, so be it. You build a query in Access that provides all data designed for your merge. You define FIELDS in Word to match the names in the Access query. Then you can trigger a MailMerge from Access and feed the query to Word along with the name of the template file. In the Word template, where you wanted data that came from the Access file, you instead put a field reference. WORD then obtains the data from the query record(s) and inserts the correct values in the specified places, after which that information is subject to whatever type of justification has been selected for that place in the template file.
Limitation: If you need more than one set of tables that are not linked or linkable to each other, you need to do MULTIPLE template files that you will then manually import to your final report. You can only do one merge query per template file.
If MailMerge doesn't meet your requirements, then the ONLY other way is to open Word as an application object and directly create the report using only common object model (ActiveX) automation. This is a daunting task that even I, as a 30+ year programmer and a 20+ year DB programmer, would hesitate to approach as anything but a last-ditch option. If you thought Access was nit-picky about VBA code, you haven't lived until you have tried to do some property adjustments to parts of paragraphs through VBA.
Given your questions, I read you as relatively new to Access or you would have known about the MailMerge function by now. (Yes, there is a way to trigger a merge from a macro, which was one part of your question.) For new persons who are not up to attacking the Word COM interface, my first and best choice is MailMerge and LIVE WITH THE RESULT. (If your boss presses you, tell him/her that it costs ten times as much to do it to exact specifications. That might be a low estimate, but money talks even when dealing with exacting bosses.)
OR generate the report and tweak it yourself with some WORD macros.
Basically, you set up a template in Word. If that template includes such things as full-justified text, so be it. You build a query in Access that provides all data designed for your merge. You define FIELDS in Word to match the names in the Access query. Then you can trigger a MailMerge from Access and feed the query to Word along with the name of the template file. In the Word template, where you wanted data that came from the Access file, you instead put a field reference. WORD then obtains the data from the query record(s) and inserts the correct values in the specified places, after which that information is subject to whatever type of justification has been selected for that place in the template file.
Limitation: If you need more than one set of tables that are not linked or linkable to each other, you need to do MULTIPLE template files that you will then manually import to your final report. You can only do one merge query per template file.
If MailMerge doesn't meet your requirements, then the ONLY other way is to open Word as an application object and directly create the report using only common object model (ActiveX) automation. This is a daunting task that even I, as a 30+ year programmer and a 20+ year DB programmer, would hesitate to approach as anything but a last-ditch option. If you thought Access was nit-picky about VBA code, you haven't lived until you have tried to do some property adjustments to parts of paragraphs through VBA.
Given your questions, I read you as relatively new to Access or you would have known about the MailMerge function by now. (Yes, there is a way to trigger a merge from a macro, which was one part of your question.) For new persons who are not up to attacking the Word COM interface, my first and best choice is MailMerge and LIVE WITH THE RESULT. (If your boss presses you, tell him/her that it costs ten times as much to do it to exact specifications. That might be a low estimate, but money talks even when dealing with exacting bosses.)
OR generate the report and tweak it yourself with some WORD macros.
