Form Field Shading

  • Thread starter Thread starter Bob Stinson
  • Start date Start date
B

Bob Stinson

I have a customer designed form made in Word. It has several text form
fields. These are completed by different people at differnent times. The
fields are not consecutive i.e person 1 completes fields 1 8 21 68 while
person 2 completes 2 16 9 etc. I want to color code the text form field
boxes to make it easire for each person to find their entries since there are
several pages to the form. Tabbing thorugh all of the nonrelevant fields
(for that person) is not an option. I am not allowed to switch the form to
Excel. I cannot shade the background of the table cell because the print out
then has either the color or shades of gray (depending on my print option).
A shaded text form field does not print the shading. That is good Can I
made the shading color for each test form field different?
 
Bob,

I you mean modify the non-printing light grey field shading then the answer
is no. Sounds like you have already experimented with other shading.

It think all you can do is use shading and then include a macro that stips
in on Save, Print, PrintPreview, etc.

You could use an autoopen macro to correctly highlight the applicable fields
for the user:

Sub Test()
Dim oFF As FormField
Dim oFFs As FormFields
Dim fldSet1() As String
Dim fldSet2() As String
Dim fldSet3() As String
Dim i As Long
Set oFFs = ActiveDocument.FormFields
ActiveDocument.Unprotect
For Each oFF In oFFs
oFF.Range.HighlightColorIndex = wdAuto
Next oFF
fldSet1 = Split("Text2 Text4")
fldSet2 = Split("Text1 Text3")
fldSet3 = Split("Text1 Text3")
Select Case Application.UserName
Case Is = "Bid Daddy Warbucks"

Case Is = "Gregory K. Maxey"
For i = 0 To UBound(fldSet2)
oFFs(fldSet2(i)).Range.HighlightColorIndex = wdYellow
Next i
Case Is = "Joe StRagman"

End Select
ActiveDocument.Protect wdAllowOnlyFormFields, True
End Sub
 
If the Print Options are set *not* to print highlighting, you could use the
highlighter to color the fields, but unfortunately the choice of colors is
pretty awful.
 
Back
Top