Formating Form

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a form that displays as a continuous form. I have
added the following code to format one of the fields
(Date Due),

If Not IsNull(Me![Date Completed]) Then
Me![Date Due].BackColor = 16777215
Me![Date Due].FontBold = False
ElseIf (Now > (Me![Date Due])) Then
Me![Date Due].BackColor = 255
Me![Date Due].FontBold = True
ElseIf ((Now + 7) > (Me![Date Due])) Then
Me![Date Due].BackColor = 65535
Me![Date Due].FontBold = True
Else
Me![Date Due].BackColor = 16777215
Me![Date Due].FontBold = False
End If

but the problem I have is that it formats all the records
based on the value in the first record. Does anyone know
if I can modify this statement to make it format each
form based on value in that particular record. Any help
is greatly appreciated.
 
Steve,
For Access 2000 and higher... check Help under Conditional Formatting. I
think that should do it for you.

hth
Al Camp
 
Back
Top