By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,161 Members | 1,024 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,161 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
CDB
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.

Nov 12 '05 #2

P: n/a
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" <al***@delete.wave.co.nz> wrote in message
news:c0**********@news.wave.co.nz...
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.


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.