Mark A Matte
markamatte at hotmail.com
Tue Jun 10 09:34:44 CDT 2008
Gustav, How would you type in TextBox1, have the KEY_UP event fire, and it NOT have focus? Thanks, Mark A. Matte > Date: Tue, 10 Jun 2008 08:00:36 +0200 > From: Gustav at cactus.dk > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] Trick Needed > > Hi Susan > > It only works when TextBox1 has focus as this is the only situation where Property Text is available. If not, you will receive an error in TextBox2. > > /gustav > >>>> ssharkins at gmail.com 10-06-2008 01:13>>> > ooooooooooo... Rocky, did it work? That is indeed clever. > > Susan H. > > >> 2 text boxes. TEXT1 and TEXT2 >> >> Private Sub Text1_KeyUp(KeyCode As Integer, Shift As Integer) >> Me!Text2.Requery >> End Sub >> >> in "CONTROL SOURCE" of TEXT2 =Len([Text1].[Text]) >> >> This shouold get what you need. > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com _________________________________________________________________ Enjoy 5 GB of free, password-protected online storage. http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_062008