Prev: Format Numbers on MS Access Report
Next: upgrading access2003 to access2007
From: Phil on 2 Aug 2010 04:23
On 02/08/2010 08:01:58, "Phil" wrote:
> On 31/07/2010 18:59:45, "Arvin Meyer" wrote:
>> Try this:
>>
>> .BodyFormat = olFormatHTML
>> .Body = ""
>> .HTMLBody = Forms!EMailText!EMailText
>>
>>
>
> Hi Arvin
>
> Have re-checked and it works nearly perfectly. I suspect there is a sort
> of bug in the memo field. My message is "This is a Rich Text Message in
> Access 2010" The "This is a Rich Text" is supposed to be in Tahoma 8 (the
> standard font of the EMailText Field), "Message" in Showcard Gothic 24 and
> "in Access 2010" in red Seago Stript 14 In debug mode,
> ?Forms!EMailText!EMailText
> <div>
> This is a Rich Text
> <font face="Showcard Gothic" size=6>message </font>
> <font face="Segoe Script" size=4 color="#ED1C24">in Access 2010</font>
> </div>
> <div>
> &nbsp;
> </div>
>
> So the initial 5 words does not get the format instruction. Consequently
> those 5 words in the email come out as Times New Roman 12 in the EMail.
>
> If I change the format of tose 5 words to Curlx MT then I get
> ?Forms!EMailText!EMailText
> <div>
> <font face="Curlz MT">This is a Rich Text </font>
> <font face="Showcard Gothic" size=6>message </font>
> <font face="Segoe Script" size=4 color="#ED1C24">in Access 2010</font>
> </div>
>
> <div>
> &nbsp;
> </div>
>
> That works perfectly. Somehow I need to insert the font instructions into
> the HTML string
>
> Phil

Came up with an unelegant solution.
Change the standard font to Wingdings so that the user has to select a
readable font once they start typing.
First  |  Prev  | 
Pages: 1 2
Prev: Format Numbers on MS Access Report
Next: upgrading access2003 to access2007