[AccessD] Instant If Then Else

Arthur Fuller artful at rogers.com
Thu Aug 12 10:57:08 CDT 2004


Any second JC will respond with a message suggesting that you use a
class for this! Write it once, use it everywhere. JC, where are you?

A.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Rodgers
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




More information about the AccessD mailing list