Thanks, but I may have to do some more as this gives me a null field and the
calculations that use this now will not work correctly with a null value.
I think I can make use of the Nz(value,0) to fix this I think.. Or if you
have better way let me know.
"CDB" <alpha@delete.wave.co.nz> wrote in message
news:c097oj$749$1@news.wave.co.nz...[color=blue]
> 1. Go to the table definition for the data, and remove the default value[/color]
of[color=blue]
> 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[/color]
field"[color=blue]
> 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" <jcmugs@hotmail.com> wrote in message
> news:102fb4gqer12k27@corp.supernews.com...[color=green]
> > I have a form that when you tab from field to field that the entry point[/color]
> is[color=green]
> > 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[/color][/color]
field[color=blue][color=green]
> > and enter 8 it is 8.
> >
> > So my question: is there an easy way to have Access XP-2002 keep the[/color]
> entry[color=green]
> > 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[/color][/color]
simple[color=blue][color=green]
> > as possible.
> >
> > Thank you.
> >
> >[/color]
>
>[/color]
