Document: http://oceanpark.com/notes/access97.html
Author: Dennis Allard
Revised:
Previous Version: none

This page is a hodge podge of rough notes I have started to keep about Access 97.

The Click Event documentation states:

In addition, if the command button doesn't already have the focus when
you choose it, the Enter and GotFocus events for the command button
occur before the Click event.

I believe it should also state:

If the Enter Event is cancelled, then the Click Event does not occur.


When trying to provide a clean way for users to enter percentage data
in Access 97, do not use input masks.  Instead, use a single precision
data field with the percent format property for both the field in the
table design and in fields in forms.

Use a precision (e.g. of 2).

IMPORTANT: The use may explicitly enter a % character when modifying
the content of the field.  Hence, entering 25.1% will actually cause
the value .251 to be entered.

There seems to be about (at least) three modes in which the field may
appear: the value being displayed in a field, the value which is
displayed when the field is selected to be modified in the case that
the value's displayed precision is adequate to show the full value and
the value which is displayed when the field is selected to be modified
in the case that the value's displayed precision is not adequate to
show the full value.  If, for example, the value is .25111 but a
precision of 1 is used, what will appear is normally 25.1%.  When you
go to modify it, it will transmute to .2511 (with no percent sign
displayed).  If, however, the value is .25 then it will appear as
25.0% even when you go to modify it.  Things get more confusing when
and if you enter a longer precision, do or do not use the % sign when
you enter a value, and especially, if you make the mistake of trying
to use in Input Mask for the field.

Just remember -- entering a % will cause the value you type to be
divided by one hundred.  If Acess has or has not predisplayed a
precent sign in the field you are modifying (which, as I tried to
explain depends on the precision of the display and what precision the
value holds), that will affect the meaning of what happens when you
press return.  If you erase the % sign when you modify the value, you
are specifying exactly the number which will become the value of the
field.  For example, 25 will mean 2500%.