want to exit a field after data input. any idea's?

B

Brizey112

in my access entry forms I would like to be able to autmatically go to the
next field without tabbing after I add the data, in other words as soon as
the data is added the focus goes direct to the next field.....
 
D

Dirk Goldgar

Brizey112 said:
in my access entry forms I would like to be able to autmatically go
to the next field without tabbing after I add the data, in other
words as soon as the data is added the focus goes direct to the next
field.....

If you use text boxes with input masks, you can do this by just setting
the control's AutoTab property to Yes. It's on the Other tab of the
control's property sheet in design view. But in the absence of an input
mask, how is Access going to know that the entry in the control is
complete?

You could code combo boxes, list boxes, check boxes, and option groups
for this behavior easily enough, by using the control's AfterUpdate
event to move the focus. But unless you want to hard-code it for each
control, you'll have to write some code to inspect the form's tab order
and figure out what control should get the focus next.
 
Top