Think you'll have to use VBA, it doesn't effect Enabled/Locked.
Private Sub Form_Current()
Dim TodaysDate As Date
TodaysDate = Date
If TodaysDate - txtShippedDate > 30 Then
txtShippedDate.ForeColor = 255
txtShippedDate.FontBold = True
Else
txtShippedDate.ForeColor = 0
txtShippedDate.FontBold = False
End If
End Sub
>From: "Steve Klein" <Stephen@K...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] conditional formatting
>Date: Mon, 25 Nov 2002 12:39:01 -0000
>
>Signed StationeryPraise be to access for giving us conditional formatting
>in
>2000. However ... ...
>
>I want to create a read only form where dates are shown. If the due date
>is
>overdue the conditional foirmatting shows it in red and bold.
>I have set the control to locked and not enabled.
>In order to do the conditional formatting, access seems to overrule the
>'enabled = false' state and leaves the control enabled
>Are there any ways of insisting that the control is not enabled after the
>formatting is complete?
>
>
>Steve K
>~~~~~~~~~~~~~~~~~~
>Steve Klein
>tel: 0118 984 5109
>mobile 0797 181 5676
>~~~~~~~~~~~~~~~~~
>
>
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail