Input Mask, Autotab Problem (1 Viewer)

mamandeno

Dabbler in Access
Local time
Today, 23:15
Joined
Jan 8, 2007
Messages
30
I am trying to speed up a data entry form, by adding input masks and autotabs.


Box1 is a text code made up of two required letters followed by two required digits. The underlying feild is a text field, the field list surce ins a text field in another table

I am using LL00 as the input mask

It won't work.


Also, is it possible to make a combo box auto tab? This would save users quite a few keystrokes per day.

Mike
 

mamandeno

Dabbler in Access
Local time
Today, 23:15
Joined
Jan 8, 2007
Messages
30
It overwrites characters 1 & 2 with 3 & 4

Ie if I enter PR21

I get (keystrokes in brackets)

(P) P
(R) PR
(2) 2R
(1) 21

and then it tells me the data doesn't match the mask.

I have since found out I can't use autotab on a combo box any way, so there may be no purpose to the input mask, since validation can be acheived by limiting to list.
 

Users who are viewing this thread

Top Bottom