last entry in a datasheet

S

Stuart1955

When I enter data into a datasheet it automatically creates another line. I
want the last line to only contain inputted data -------------- How do I stop
the datasheet expanding beyond my data input?
 
H

Hunter57

Hi Stuart,

Autonumber automatically adds a new line. If you have default values for
anything set in your Tables or Forms it will show up in the new line also.
You could run a query that has Is Not Null as the criteria for one of your
fields.

Hunter57
Just huntin' for some data.
http://churchmanagementsoftware.googlepages.com
 
J

John W. Vinson

When I enter data into a datasheet it automatically creates another line. I
want the last line to only contain inputted data -------------- How do I stop
the datasheet expanding beyond my data input?
Click to expand...

So you want to be able to input as many lines of data as you want to input...

and then have Access "sense" that you're done and not allow any more!?

The telepathic interface package is still under development I fear! <g>

You can set the "Allow Additions" property of a form to No in order to remove
the "new record" line and see only existing data. Of course that means that
you can't *add* any new records (with that form).


John W. Vinson [MVP]
 
Top