Formating Form

[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.

 

[AlCamp]

Steve,
For Access 2000 and higher... check Help under Conditional Formatting. I
think that should do it for you.

hth
Al Camp