How do I create Access reports with Excel Grid style?

mx,

I can't find "Tabular Layout" in the wizard, where can I find it? Btw, I'm using MS Access 2003

Why not just format each field on the report to display 3 lines.

ET

ET you have the reverse problem of the CanGrow, the example shown is growing and shrinking the detail section.
Cheers, Andrew

>>>>ET you have the reverse problem of the CanGrow, the example shown is growing and shrinking the detail section.<<<<

Not really, when you look at the Excel report (which is basically 3 lines per record).

Basically, set the size of "ALL" detail controls to display 3 lines (unless there are records with more than 3 lines to print).  

ET

ET take another look at project No 5 and 8 they are definately less than 3 lines.
Cheers, Andrew

bujang6,

I'm with MX,
<Try using the Tabular Layout in the Wizard>

AFAICT, by looking at both screenshots, if the report is Tabular, it will get you what you want.

<I can't find "Tabular Layout" in the wizard, where can I find it?>
Tabular layout is not a choice OF a report, it is an option IN the chart wizard.
Open the chart wizard
Select your fields
DO NOT SELECT ANY GROUPING
Select your sort order
In the next screen, select the "Tabular" layout.

(Points to MX if this is acceptable)

JeffCoachman

"Tabular layout is not a choice OF a report,"

It is in my wizard (which I never use).

mx

Boag2000 and DatabaseMX, have MS changed the CanGrow and Canshrink to have an option that grows all controls to the height of the tallest in the section rather than just affecting the individual controls, the screen shot from bujang6 is exactly what I would expect in an access report when using the borders of controls with CanGrow and/or CanShrink options.

Chees, Andrew

TextReport,

I'm running 2000 and 2003 (No SP's), Can grow and shrink for 1 control, only affect the one control.
(Although some times I accidentally set the prop when all the controls are seleted!)
:-O

Jeff

Thanks Jeff, do you therefore agree that the OnPage is the only way with the CanGrow set to yes to get the layout bujang6 is after.
Cheers, Andrew

MX,

Sorry, I meant that since they said:
<I can't find "Tabular Layout" in the wizard>
I thought they might not have found it because they were looking for it in the database window, on the Reports tab:
-Create Report in Design View
-Create Report by using Wizard
rtp1
rpt2
...ect

(I rarely click the "New" Icon)
:-O

Sorry for the confusion
;-)

JeffCoachman

Are we having fun yet :-)

mx

Andrew,
Now I know that there was no wizard/easy way for my case. I can now create similar reports with your solution (& extra efforts :-) ). Thanks


MX,
I found out that Tabular layout cannot be used with Grouping. In this case I need to group some fields (It wasn't shown in Excel attachment as the column was hidden, I just realize it). But thanks for your info, it will be very useful next time if I need to create reports without Grouping.