Prev: Web component issue
Next: Compact and Repair Problem
From: kendraarianna on 3 Jul 2008 19:37
Is there a way to automatically move to the next field once a set number of
characters has been keyed. Ex. I set a field in access 2003 to a limit of 5
characters. Once I keyed the 5 characters I want to automatically advance to
the next field.
From: Jeff Boyce on 3 Jul 2008 19:52
One of the possible "unintended consequences" of doing this might be that a
user would type 8 characters, the first five of which would show up in that
control, and the final 3 would show up in the NEXT control!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"kendraarianna" <kendraarianna(a)discussions.microsoft.com> wrote in message
news:C5DEC266-B770-4AB5-9116-1337AA501A14(a)microsoft.com...
> Is there a way to automatically move to the next field once a set number
> of
> characters has been keyed. Ex. I set a field in access 2003 to a limit
> of 5
> characters. Once I keyed the 5 characters I want to automatically advance
> to
> the next field.


From: fredg on 3 Jul 2008 19:55
On Thu, 3 Jul 2008 16:37:00 -0700, kendraarianna wrote:

> Is there a way to automatically move to the next field once a set number of
> characters has been keyed. Ex. I set a field in access 2003 to a limit of 5
> characters. Once I keyed the 5 characters I want to automatically advance to
> the next field.

Let's assume the name of this control is "LastName" and the 'next
field' on your form is named "FirstName".

Code the [LastName] control's Change event:

If Len(Me.[LastName].Text) >= 5 then
Me.[Firstname].SetFocus
End If

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
From: John W. Vinson on 3 Jul 2008 20:12
On Thu, 3 Jul 2008 16:37:00 -0700, kendraarianna
<kendraarianna(a)discussions.microsoft.com> wrote:

>Is there a way to automatically move to the next field once a set number of
>characters has been keyed. Ex. I set a field in access 2003 to a limit of 5
>characters. Once I keyed the 5 characters I want to automatically advance to
>the next field.

If the field will ALWAYS contain five characters, no more no fewer, you can
set the textbox's Auto Tab property to Yes.

This assumes you're using a Form. Do so. Table datasheets are VERY inflexible
and limited, and not suitable for use for data entry any professional
application.
--

John W. Vinson [MVP]
From: Linq Adams via AccessMonster.com on 3 Jul 2008 21:33
Also note that in order to use the Auto Tab property you also have to have an
Input Mask set for the textbox in question. As John said, it will only Auto
Tab if the maximum number of allowed characters is entered. If you have
optional characters in the Input Mask and some of these are left out, the
Auto Tab won't take place.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200807/1

 | 
Pages: 1
Prev: Web component issue
Next: Compact and Repair Problem