[AccessD] Instant If Then Else

If you're using A2K or higher, use Conditional Formatting.
It's easy to set up and it's instantaneous.
HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Paul Rodgers
Sent: Thursday, August 12, 2004 10: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