Tabular versus DataSheet

[Guest]

I have a 1:m form using 2007. In the subform part of the form I would like
for it to look like a spreadsheet. A datasheet view seems a good choice and
I like its looks and functionality; you can sort and filter the rows easily
etc. However, at the present I am using a tabular style instead. This is
because, in a tabular style, I have figured out how to get a subtotal on a
column in the form that contains an expression. I have not been able to
figure out how to do this with the datasheet; not for an expression.

Is there a general consensus on what works best for child subforms, that is,
DataSheet versus Tabular. The tablular has too much spacing and I don't see
how to filter or sort the columns as easily as a DataSheet. On the other
hand, the DataSheet doesn't to subtotals easily for expressions.

Any suggestions or can someone point me to a white paper that might talk
about this?

 

[Guest]

I have answered my own question. Sorry! I am still somewhat new to Access.

I have discovered that a Tabular format does all that I want. However, it
would be nicer if the spacing between columns and rows were narrower.

 

[John W. Vinson]

I have discovered that a Tabular format does all that I want. However, it
would be nicer if the spacing between columns and rows were narrower.

You can set the spacing however you like. Open the Form in design view; to get
a datasheet-like look, snug all the textboxes up against the top of the detail
section, and drag the bottom of the detail section up to the bottom of the
textboxes. Also drag all of the textboxes to touch each other (or select all
the textboxes and repeatedly use Format... Horizontal Spacing to bring them
closer).

John W. Vinson [MVP]

 

[Guest]

Thank you. Doing what you said and turing off padding got me there. I didn't
understand one thing you said. You said:

or select all
the textboxes and repeatedly use Format... Horizontal Spacing to bring them
closer

I suppose you mean that there is a property for the fields (in the format
tab) called Horizonatal spacing; but I see not such property.

Thank you again.

 

[John W. Vinson]

Thank you. Doing what you said and turing off padding got me there. I didn't
understand one thing you said. You said:


I suppose you mean that there is a property for the fields (in the format
tab) called Horizonatal spacing; but I see not such property.

sorry... I was very obscure there!!!

I meant to use the Format menu item on the forms design window. It's a
dropdown offering a number of formatting options, one of which is horizontal
spacing if there are multiple controls selected.

John W. Vinson [MVP]