Andy Lacey
andy at minstersystems.co.uk
Fri Mar 16 09:23:54 CDT 2007
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