[AccessD] Instant If Then Else

Use the OnEnter event of the text box.

JWC

-----Original Message-----
From: Paul Rodgers [mailto:Paul.Rogers at SummitMedia.co.uk]
Sent: Thursday, August 12, 2004 11:36 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Instant If Then Else


Can I make these changes the instant the User enters a text box, please?

If Not IsNull([txtFun]) Then

        Me.txtFun.BackColor = vbRed
            Me.txtFun.ForeColor = vbYellow

                Else

            Me.txtFun.BackColor = vbWhite
        Me.txtFun.ForeColor = vbBlack

    End If

I mean as he types "y" for "yes", or anything at all? The above doesn't work
till the record changes. 

Cheers paul

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com