Clicking on Control

[molsonexpert]

I have small but aggravating issue: I have a form in datasheet view. Only
one column is used for data entry. After data has been entered in a control,
you can't click to position the mouse cursor in another control in that same
column (above or below it); you have to click in the field to the right or
left of the original control (i.e. the same record) before being allowed to
proceed. Is this by design?

steve.

 

[Allen Browne]

No, it's not by design.

I take it that:
- You have a control (call it Field2).
- You enter a value.
- Then you click in Field2 in the row below.
- It does not move to the row below.
- There is no error mesage, but you have to click again.

I'm guessing there is some event that is preventing it from moving. It may
be an event of the control (e.g. KeyDown, Change, BeforeUpdate,
AfterUpdate), or an event of the form (e.g. KeyDown, BeforeUpdate,
AfterUpdate, Current, or Timer). Temporarily removing the event procedures
will help you pin-point it.

 

[molsonexpert]

No, it's not by design.

I take it that:
- You have a control (call it Field2).
- You enter a value.
- Then you click in Field2 in the row below.
- It does not move to the row below.
- There is no error mesage, but you have to click again.

I'm guessing there is some event that is preventing it from moving. It may
be an event of the control (e.g. KeyDown, Change, BeforeUpdate,
AfterUpdate), or an event of the form (e.g. KeyDown, BeforeUpdate,
AfterUpdate, Current, or Timer). Temporarily removing the event procedures
will help you pin-point it.

Thanks for the reply. In the meantime, i had figured it out, but i still
don't know the reason. I had a macro run in the 'On Exit' property for that
control. When I removed it and put it in 'After Update' (which accomplishes
what I wanted as well), the problem goes away.

thanks again.

steve.