subform tab order problem

[Mark1 via AccessMonster.com]

The first field in my sub-form is a short-date field. The input mask for
this field is set at the form level, not the table level. If I enter data in

that field and hit the tab button, the cursor jumps to field 2 (like I want
it to), but then immediately jumps back into the first field, highlighting
the value. If I hit Tab again, it goes to field 2 again without issue. Has
anybody experienced this before?

I thought it might have something to do with the input mask, because when I
highlight the first field (short date field), a template of __/__/____ is
automatically put in. I enter 0-5-0-5-2-0-0-6, hit tab, the field is
shortened to 5/5/2006 while the cursor goes to field 2, but then cursor
immediately comes back into the first field and highlights the value 5/5/2006.


It seems to jump back to whatever field I have as tab order 0 .

Thanks for any help.

 

[Joan Wild]

If you feel the input mask is causing some problem, have you tried removing
it? Does it correct the problem?

I never put an input mask on a date field, as I find it just gets in the way
and slows down data entry. Are you aware that the user can just enter month
and day
e.g.. 2/13
and Access will assume the current year. That's much quicker than 02132007.

It does require that the user get familiar with the Regional Settings on
their computer ( change the RS to their liking). If the short date format
in RS is set to dd/mm/yyyy, then the user needs to enter 13/2.

You can and should make use of the format property. Set it to something
unambiguous, so the user can see right away if a data entry is interpreted
wrong. Something like dd/mmm/yyyy or mmm/dd/yyyy

If removing the input mask doesn't solve the focus problem, check the code
behind the form and the subform - something is causing the requery. Also,
does this happen if you hit tab twice - does it bounce back to 1?