Datasheet column autofills downwards Access2000

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi
Suppose I have a query with 3 columns:-
ProductID/ProductName/OrderQty.
This query is based on the stock of a major supplier. It
returns all the suppliers products and I go down the list
and enter the quantity i require for each product or none
at all if not required. I can then refresh the query to
exclude those with zero on order. The point is that if I
enter 1 for a product and then 2 for the next one, Access
fills in 3 for the next row and so on. How can I turn this
off. It is very annoying, especially if someone else has
to do the ordering who isnt as sharp at spotting things
like this.
Any help is appreciated
Steve
 
Steve said:
Hi
Suppose I have a query with 3 columns:-
ProductID/ProductName/OrderQty.
This query is based on the stock of a major supplier. It
returns all the suppliers products and I go down the list
and enter the quantity i require for each product or none
at all if not required. I can then refresh the query to
exclude those with zero on order. The point is that if I
enter 1 for a product and then 2 for the next one, Access
fills in 3 for the next row and so on. How can I turn this
off. It is very annoying, especially if someone else has
to do the ordering who isnt as sharp at spotting things
like this.
Click to expand...

You can't turn the feature off, but you can use a form instead of a
Datasheet or you can apply a default value to the field and that will
override the "auto-fill" value that would otherwise show up. I don't know
if you can specify Null as the default though. A zero, while maybe not
what you would prefer would at least provide for a consistent entry and
would allow you to not make an entry at all for those parts you weren't
ordering.
 
I don't know
if you can specify Null as the default though.
Click to expand...

Rick,
You can specify Null as a default value, however, it has no effect on the
"auto-fill" misfeature. Null is the default value if none is actually
specified.
 
Back
Top