[AccessD] Access to Word - colour an area

...just a wag here Andy but if that were put to me I'd be thinking about 
dumping Word and doing the entire thing as an Access report using Lebans rtf 
control ...I've converted almost all of my client's Word mail merge docs to 
Access reports this way ...takes a bit more work on your part but once the 
forms are up, the clients love the things that can be done with a report 
while retaining the ability to change text content and formatting.

William

----- Original Message ----- 
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, March 16, 2007 10:23 AM
Subject: Re: [AccessD] Access to Word - colour an area


> It's still a what-if at the moment. I'm going to see a potential client 
> next
> week. He's described the project and this is a part of it. I'm just 
> wanting
> to be forearmed.
> I suspect it's possible anything could be inside the box, most likely text
> and mailmerge entries, and all of it would want the coloured background. 
> But
> could it be done in a generic way by, I dunno, putting bookmarks at top 
> left
> and bottom-right of the area and selecting all between them, or something
> like that? OTOH I don't know how you set a bookmark as the bootom-right of
> an area.
> --
> Andy Lacey
> http://www.minstersystems.co.uk
>
>
>
> --------- Original Message --------
> From: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Access to Word - colour an area
> Date: 16/03/07 14:05
>
>
> On 3/16/07, Andy Lacey <andy at minstersystems.co.uk> wrote:
>> Hi all
>> If you have a Word doc, to be used as the master for a mailmerge, and an
>> area on it has a border round it, how would you (from Access) go about
>> filling that area a different colour depending upon a value on someone's
>> record? In its simplest form how would you use the Word object to 
>> identify
> a
>> bordered area and give it a different colour?
>>
>> (Thinks - wonder if anyone will get this before Bryan. There's a
> challenge.)
>
> On my way to a 2 hour meeting, but I do have a couple of questions.....
>
> What is the area that is bordered? Text Box, Paragraph, table? Would
> the merge field be in the area to be coloured?
>
> I am assuming that you want to keep all your code in Access, correct?
>
> PS, since this is Mail Merge, you'll probably get a better answer from
> someone else, 'cause I don't use mm very often. Oh who's kidding who,
> I don't do much any more besides sit in meetings. <sigh>
>
> --
> Bryan Carbonnell - carbonnb at gmail.com
> Life's journey is not to arrive at the grave safely in a well
> preserved body, but rather to skid in sideways, totally worn out,
> shouting "What a great ride!"
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> ________________________________________________
> Message sent using UebiMiau 2.7.2
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>