Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Re: conditional formatting


Message #1 by "Bob Bedell" <bobbedell15@m...> on Wed, 11 Dec 2002 16:04:32 +0000
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


  Return to Index