If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Send to Word not listening to Access???
Hello All,
The below code is on the On Format and On Print of the report Detail section. Works beautifully as long as I preview and print from within Access. However, if I transfer to Word and 1(one) txtPromiseDate is 193(red), then the whole coulmn is 193(red). What am I doing wrong? Thanks in advance, Gina On Error Resume Next If (Me.txtNC) = 4 Then Me.txtPromiseDate.ForeColor = 193 Me.txtPromiseDate.FontWeight = 700 Else Me.txtPromiseDate.ForeColor = 0 Me.txtPromiseDate.FontWeight = 400 End If |
#2
|
|||
|
|||
Send to Word not listening to Access???
Gina:
Have you tried only putting the code in the On Print event rather than in both places? -- Steve Arbaugh ACG Soft http://ourworld.compuserve.com/homepages/attac-cg "Gina Whipp" wrote in message ... Hello All, The below code is on the On Format and On Print of the report Detail section. Works beautifully as long as I preview and print from within Access. However, if I transfer to Word and 1(one) txtPromiseDate is 193(red), then the whole coulmn is 193(red). What am I doing wrong? Thanks in advance, Gina On Error Resume Next If (Me.txtNC) = 4 Then Me.txtPromiseDate.ForeColor = 193 Me.txtPromiseDate.FontWeight = 700 Else Me.txtPromiseDate.ForeColor = 0 Me.txtPromiseDate.FontWeight = 400 End If |
#3
|
|||
|
|||
Send to Word not listening to Access???
Nope, but I will now.
"SA" wrote in message ... Gina: Have you tried only putting the code in the On Print event rather than in both places? -- Steve Arbaugh ACG Soft http://ourworld.compuserve.com/homepages/attac-cg "Gina Whipp" wrote in message ... Hello All, The below code is on the On Format and On Print of the report Detail section. Works beautifully as long as I preview and print from within Access. However, if I transfer to Word and 1(one) txtPromiseDate is 193(red), then the whole coulmn is 193(red). What am I doing wrong? Thanks in advance, Gina On Error Resume Next If (Me.txtNC) = 4 Then Me.txtPromiseDate.ForeColor = 193 Me.txtPromiseDate.FontWeight = 700 Else Me.txtPromiseDate.ForeColor = 0 Me.txtPromiseDate.FontWeight = 400 End If |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
In Word, how do I surpress headers and footers on page 2 | Bill | General Discussion | 1 | December 15th, 2005 06:13 PM |
word and wordperfect mail merges | slgcms | Mailmerge | 2 | September 27th, 2005 02:13 PM |
How to change merge forms from Word Perfect to Microsoft Word | Charles Kenyon | General Discussion | 1 | December 30th, 2004 03:35 PM |
WORD XP mail-merge FAILS using ACCESS query | SueMackay | Running & Setting Up Queries | 4 | November 29th, 2004 04:11 PM |
WORD XP mail-merge FAILS using ACCESS Query | SueMackay | Mailmerge | 1 | November 23rd, 2004 01:03 PM |