[AccessD] Word merge document

Heenan, Lambert Lambert.Heenan at chartisinsurance.com
Tue Jul 6 09:23:55 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.

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?
> 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list