Input Mask, Autotab Problem

mamandeno

Dabbler in Access
Local time
Tomorrow, 00:32
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
 
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

Back
Top Bottom