0 or blank Data Entry field on a form when tabing or clicking to enter

[JC Mugs]

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.

[CDB]

Re: 0 or blank Data Entry field on a form when tabing or clicking to enter

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" <jcmugs@hotmail .com> wrote in message
news:102fb4gqer 12k27@corp.supe rnews.com...[color=blue]
> I have a form that when you tab from field to field that the entry point[/color]
is[color=blue]
> 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[/color]
entry[color=blue]
> 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.
>
>[/color]

[JC Mugs]

Re: 0 or blank Data Entry field on a form when tabing or clicking to enter

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.w ave.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:102fb4gqer 12k27@corp.supe rnews.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]