|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 30th, 2006, 01:42 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Jump from one textbox to another
Is it possible when user enters date in date1 textbox cursor
automatically jump to date2 text box. My settings are as follows: input mask 00/00/00 format property mm/dd/yy Thank You. 
|
|
#2
August 30th, 2006, 02:01 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Jump from one textbox to another
you can perhaps determine the length of the string inputted in date1.
and set the focus to the dat2 field as soon as all numbers are filled in at the dat1 field (in afterupdate_dat1 sub) if len(me.dat1.value)=6 then me.dat2.setfocus endif On 30 Aug 2006 05:42:25 -0700, "Anna" wrote: Is it possible when user enters date in date1 textbox cursor automatically jump to date2 text box. My settings are as follows: input mask 00/00/00 format property mm/dd/yy Thank You.
|
|
#3
August 30th, 2006, 02:02 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Jump from one textbox to another
On after update event of your first textbox set the focus to the other
textbox as Me.NameOfTextBox2.SetFocus
|
|
#4
August 30th, 2006, 02:21 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Jump from one textbox to another
when i run the script in debug mode Len(Me.Date1.Value), it shows null.
If Len(Me.Date1.Value) = 6 Then Me.Date2.SetFocus End If --------------------------------------------------- Toine wrote: you can perhaps determine the length of the string inputted in date1. and set the focus to the dat2 field as soon as all numbers are filled in at the dat1 field (in afterupdate_dat1 sub) if len(me.dat1.value)=6 then me.dat2.setfocus endif On 30 Aug 2006 05:42:25 -0700, "Anna" wrote: Is it possible when user enters date in date1 textbox cursor automatically jump to date2 text box. My settings are as follows: input mask 00/00/00 format property mm/dd/yy Thank You.
|
|
#5
August 30th, 2006, 04:50 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Jump from one textbox to another
If you want to try Toine's suggestion, use Text property:
If Len(Me.Date1.Text) = 6 Then Me.Date2.SetFocus End If -- Ken Snell MS ACCESS MVP "Anna" wrote in message ups.com... when i run the script in debug mode Len(Me.Date1.Value), it shows null. If Len(Me.Date1.Value) = 6 Then Me.Date2.SetFocus End If --------------------------------------------------- Toine wrote: you can perhaps determine the length of the string inputted in date1. and set the focus to the dat2 field as soon as all numbers are filled in at the dat1 field (in afterupdate_dat1 sub) if len(me.dat1.value)=6 then me.dat2.setfocus endif On 30 Aug 2006 05:42:25 -0700, "Anna" wrote: Is it possible when user enters date in date1 textbox cursor automatically jump to date2 text box. My settings are as follows: input mask 00/00/00 format property mm/dd/yy Thank You.
|
|
#6
August 31st, 2006, 08:16 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Jump from one textbox to another
If a textbox has an input mask, you can just set its Autotab property to
make the focus jump to the next control in tab order when the user has typed enough characters to "fill" the input mask. On 30 Aug 2006 05:42:25 -0700, "Anna" wrote: Is it possible when user enters date in date1 textbox cursor automatically jump to date2 text box. My settings are as follows: input mask 00/00/00 format property mm/dd/yy Thank You. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
