Table acting like a Form

[GregoryWest]

I have what was supposed to be a table sub-form in Access 2010. Just a list of short records relating to the parent record. For some reason this has switched to a form type view, ie showing only one record at a time, not the list of records.


Question is how did I mess this up?
How to I put it back to showing me a list, instead of a single record at a time?

 

[theDBguy]

Hi,

Can you go to the Design View of the subform and check to make sure the Default View is set to Datasheet?

 

[Gasman]

You can also disallow the other views to stop it happening again.

 

[GregoryWest]

That was the problem, was set to Single Form, instead of continuous forms. Now I just have one other issue, two fields (both descriptions) have been flagged "Can Grow" but they don't grow. This is even when data is being cut off because of the lack of growth.

 

[theDBguy]

Hi,

CanGrow is a misunderstood property. It only applies to printing a report or form. It does not work for screen display.

 

[June7]

It works for report in Report or PrintPreview or to printer. Don't know about form to printer.

Textbox bound to a Memo (long text) type field will have a vertical scroll bar.

 

[theDBguy]

Hi June7,

Thanks for the correction. Report View is something new since Access 2007, Print Preview is a screen representation of the printed version, so it has to include any height adjustments. I am pretty sure it will work on forms when printed.

Cheers!

 

[GregoryWest]

AH OK.... that makes sense

 

[missinglinq]

...I am pretty sure it will work on forms when printed...

That be correct!

Linq ;0)>