datasheet

  • Thread starter kennytwk via AccessMonster.com
  • Start date
K

kennytwk via AccessMonster.com

Hi,
i have a question, i have create a form in datasheet view with three columns,
but each columns have only 1 cells, how do i display a list of cells without
connecting to any table?

i want to have my datasheet empty so that i can key data into it. is it
possible?
i want my datasheet sheet to look like an empty table.
 
D

Douglas J. Steele

The single blank row (indicating the next new record) is the only real
possibility.
 
J

John Vinson

Hi,
i have a question, i have create a form in datasheet view with three columns,
but each columns have only 1 cells, how do i display a list of cells without
connecting to any table?

i want to have my datasheet empty so that i can key data into it. is it
possible?
i want my datasheet sheet to look like an empty table.
Click to expand...

If you open a Form (or Subform) with its Data Entry property set to
Yes, you'll get just a blank new-record line. The moment you type
something into that row you'll get a NEW blank line below it, ready
for more records when you finish the first one. You'll keep getting
new records as long as you keep adding data.

If you want a form with all blank records sitting there waiting to be
filled... you're going against the grain of how Access works. It's not
necessary to have blank records pre-entered into your table, given
that the "new record" is endlessly provided!

John W. Vinson[MVP]
 
Top