1. Go to the table definition for the data, and remove the default value of
zero for that field. (Microsoft are very helpfully makes an automatic
default value of zero for when you create a numeric field. In 10 years of
using access, I have never wanted to have such a default value!)
2. Leave the default value as it is, and Go to Tools/options. In the
keyboard camp, change "behaviour entering Field" from "Go to start of field"
to "Select entire field".
3. There could be code is attached to the "Before Insert" event. (This is
the technique I use.) The code would need to be modified.
Clive
"JC Mugs" <jc****@hotmail.com> wrote in message
news:10*************@corp.supernews.com...
I have a form that when you tab from field to field that the entry point
is blank, but if you point and click in the field it brings up a 0 and data
entry is started to the left of the zero.
Thus if you are click and enter 8 becomes 80, but if you tab to the field
and enter 8 it is 8.
So my question: is there an easy way to have Access XP-2002 keep the
entry on the form blank when you click on a field to enter data?
If you need more information to please ask, as I want to keep it as simple
as possible.
Thank you.