Need to double-click or f2 to update field on form?

  • Thread starter Thread starter jjjax
  • Start date Start date
J

jjjax

This maybe be something stupid but since going to Access 2000 to 2007, when a
user tried to edit a field on a form, they need to double-click in the field
or click once and press f2 to edit. If they only click once, then key in
something, it overwrites entire field's data. It acts as if the whole field
is selected even though it doesn't show as highlighted. I think I have seen
this in Excel but in Access 2000, we never had to do this. Not a major deal
but users are so use to just clicking for last 10 years so just want to see
if there is a way around this?

Thanks, Joe
 
Hi jjax,
no one has mentioned this problem in A2007 over the last 2 years.
It never happens in my 07 apps. Is it possible that something in the code
behind the form is doing this?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Hi, thanks for the reply. I played around some more and created a new form
and it didn't seem to be a problem so start comparing all property settings
and have it narrowed down to the form that is giving us the problem has an on
dirty event which just updates a form field to now() so we can know whenever
anything was changed. If I disable this event, it seems to work fine and if
I do some other code other than updating a form field, it seems to be ok too.
This works ok under access 2000 but seems to be handling differently on
2007?
 
Interesting. As far as I know, most Access MVP's avoid putting code in the
Dirty event of forms and don't recommend it in answers on the discussion
groups. Maybe this is why others have not reported a similar problem.

If you want to mark a record as changed, you can use the form's after update
event to insert Now() into a table.
You can also do this in the before update event after you are sure that all
form level validations have been passed.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Interesting. As far as I know, most Access MVP's avoid putting code in the
Dirty event of forms and don't recommend it in answers on the discussion
groups. Maybe this is why others have not reported a similar problem.

If you want to mark a record as changed, you can use the form's after update
event to insert Now() into a table.
You can also do this in the before update event after you are sure that all
form level validations have been passed.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
Click to expand...

--
 
Back
Top