T
tricky300
Hi,
Thanks to anyone who can help.
I have tested this in a simplified (Access 2007) environment.
Create a new blank Access database
Create a table with 3 fields:-
id (text primary key)
f1 (date)
f2 (text)
create 1 record with just a key leaving f1 and f2 blank
create a simple form with 2 controls that will modify f1 and f2 (but not the
key)
open the form and change the date in f1 by using the date picker (you must
use the date picker to reproduce the fault) and use TAB (or RETURN) to go to
the f2 control (do not go there by clicking as this will not reproduce the
fault).
Hit Alt-F11 to go to the vb editor and you will get an hourglass that will
only go away when you click something at which point the vb editor will close!
This behaviour gave me huge grief in a much more complicated environment and
has taken me hours to track down as I originally assumed that it was my vb
code causing the problem.
Thanks to anyone who can help.
I have tested this in a simplified (Access 2007) environment.
Create a new blank Access database
Create a table with 3 fields:-
id (text primary key)
f1 (date)
f2 (text)
create 1 record with just a key leaving f1 and f2 blank
create a simple form with 2 controls that will modify f1 and f2 (but not the
key)
open the form and change the date in f1 by using the date picker (you must
use the date picker to reproduce the fault) and use TAB (or RETURN) to go to
the f2 control (do not go there by clicking as this will not reproduce the
fault).
Hit Alt-F11 to go to the vb editor and you will get an hourglass that will
only go away when you click something at which point the vb editor will close!
This behaviour gave me huge grief in a much more complicated environment and
has taken me hours to track down as I originally assumed that it was my vb
code causing the problem.