Forms like Table

[FahadTiger]

Hi everyone ..
is there any way to show the subform like the table even if its Fields are empty

 

[theDBguy]

Try using datasheet view.

 

[FahadTiger]

Try using datasheet

Im try it but nothing ..like this

 

[Pat Hartman]

That is the way it is supposed to be. What is wrong with what you are seeing?

q and p are not meaningful names. How is an untrained user supposed to figure out what to put in those fields? If you don't want to see the zeros in the empty record, set the default on the fields in the table to null rather than 0.

 

[FahadTiger]

there is No wrong...I want it to look like a table from an aesthetic point of view

That is the way it is supposed to be. What is wrong with what you are seeing?

q and p are not meaningful names. How is an untrained user supposed to figure out what to put in those fields? If you don't want to see the zeros in the empty record, set the default on the fields in the table to null rather t

 

[Uncle Gizmo]

is there any way to show the subform like the table even if its Fields are empty

Why are the fields Empty?

Or rather, the fields are never going to be empty if you are collecting data, so your requirement is unnecessary by default...

 

[FahadTiger]

Why are the fields Empty?

Or rather, the fields are never going to be empty if you are collecting data, so your requirement is unnecessary by default...

I know that Sir ... But Ilike to see the sub form as the table when its empty
its just I like it

 

[Uncle Gizmo]

But Ilike to see the sub form as the table when its empty
its just I like it

Well that's a good reason!

Three ways spring to mind.

1) Add some empty records to your table.

2) If you don't want empty records in your table, then create a new table, add Empty records to it. Switch the record source of the subform between these two tables to suit.

3) Place an image of an empty table over the form and make it visible or invisible to suit.

 

[June7]

Don't understand issue. It looks like a table to me.

 

[FahadTiger]

Why are the fields Empty?

Or rather, the fields are never going to be empty if you are collecting data, so your requirement is unnecessary by default...

Uncle Gizmo.. maybe my Question is not clear..when I open the Form to record in the field its to be like empty sheet excel​

 

[MajP]

You want to see a bunch of empty rows? Could be done with a lot of work, but would no make any sense. Unlike a worksheet a table grows only when entering records. Empty records do not exist.

 

[June7]

But it shows empty 'rows' and 'cells' to fit the table window frame, just without alternate row color. Form in datasheet view looks like table to me. What else would you want? Still don't understand issue.

 

[Uncle Gizmo]

@Uncle Gizmo.. maybe my Question is not clear..when I open the Form to record in the field its to be like empty sheet excel

I believe I understood and answered. If my answers missed the mark, please explain...

 

[mike60smart]

Uncle Gizmo.. maybe my Question is not clear..when I open the Form to record in the field its to be like empty sheet excel​

Hi
I believe everyone has been very clear.

There is a major difference between Excel and Access.

Excel displays multiple Blank Rows waiting for data to be entered into each cell.

Access Displays 1 Record which shows a Blank for Each Field from the underlying Table

 

[June7]

I am not able to replicate that form showing only one blank row.

 

[mike60smart]

I am not able to replicate that form showing only one blank row.

Hi June
Here is the Form

 

[June7]

Oh, Continuous View, not Datasheet.

If don't want to show existing records when form opens (regardless of view), set DataEntry property to Yes.