[AccessD] Word merge document

jwcolby jwcolby at colbyconsulting.com
Tue Jul 6 09:55:22 CDT 2010


 > What about using just one field in the Word doc that holds everything you want printed on that 
line? Then build its contents up in your code using Lset to left justify the string on a consistent 
basis.

Uh... no.  Though that is a novel idea.  This is a word document pulling data directly out of a CSV 
file, and inserting it into merge fields on a document.

What is the point of a merge document if I have to do what you are discussing?

John W. Colby
www.ColbyConsulting.com


Heenan, Lambert wrote:
> What about using just one field in the Word doc that holds everything you want printed on that line? Then build its contents up in your code using Lset to left justify the string on a consistent basis.
> 
> Lambert
> 
>  
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Tuesday, July 06, 2010 9:29 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Word merge document
> 
> Gustav,
> 
> The problem is the stinkin user (you know users)
> 
> She wants it to look like the document that she prints for anyone who just fills out the form manually, so that a person going through these on the first day of VBS can see all registration documents looking the same.
> 
> So I have a field in my merge document that looks like:
> 
> Child/Youth Name: <<Name1>>	Date of Birth: <<DOB1>>
> Niño/joven # 1:  Nombre		Fecha de nacimiento:
> 
> 
> The words on the consecutive lines need to line up with each other, which I can do with tabs (or spaces).  However as the length of <<Name1>> changes, it pushes Date Of Birth out to the left, but of course it does not push Fecha de nacimiento around.  And in the end it shouldn't push anything around.
> 
> This is just ugly!  It seems like you should be able to "paint" the document such that <<Name1>> is a fixed width on the final form.  No tabs after it, it just takes X inches of space on the line.
> 
> But the merge field has no handles, no obvious way to say "this field is always X units wide".  This seems like something that everyone would want and would have been fixed ohhh.... TWENTY years ago?
> 
> 
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> 
> Gustav Brock wrote:
>> Hi John
>>
>> Tables?
>>
>> /gustav
>>
>>
>>>>> jwcolby at colbyconsulting.com 06-07-2010 14:47 >>>
>> The problem I am having is that the data fields shift around as the length of the data changes if I have multiple fields on the same line.
>>
>> IOW:
>>
>> Name	<<NameData>>	DOB	<<DOBDATA>>
>>
>> causes <<DOBData>> to slide left and right as the length of the <<NameData>> changes.
>>
>> I cannot seem to find a way to permanently make the fields themselves a specific (fixed) length.
>>
>> Does anyone know how to fix this?
>>



More information about the AccessD mailing list