Columns

[user777]

I have a report with 8 1" columns running vertically down the page/report
and the data wraps around at the bottem and begins again at the top of the
next column and continues like this across the page/report. This is fine--not
the problem.

The problem is on the last page the columns do not make it all the way
across the page/report; they end halfway (i.e. I have 3 1/2 full columns on
the last page). What I want is a way to fill the space with the remaining
columns. Instead of having the columns run all the way down the
page/report, I want them to continue as they do, but end at a certin point
so they are all the same length down the page/report but fill 8 1" columns.

For the visual: This: 1 2 3 To: 1 2 3 4 5 6 7 8
t t t t t t t t t t t
t t t t t t t t t t t
t t t t t t t t t t t
t t
t t
t t



Let me know if this makes any sense.

 

[Duane Hookom]

This makes sense but the solution is not easy. I have done this by setting
the report columns to display across then down. Since this is probably not
the order you desire, you must create a calculated value in your report's
record source that can be used in the report's Grouping and Sorting dialog so
that the records appear to display down then across.

I use a complex DCount() in the record source to provide the order/sequence
value.

 

[Chuck]

This makes sense but the solution is not easy. I have done this by setting
the report columns to display across then down. Since this is probably not
the order you desire, you must create a calculated value in your report's
record source that can be used in the report's Grouping and Sorting dialog so
that the records appear to display down then across.

I use a complex DCount() in the record source to provide the order/sequence
value.

Can VBA use a Tab Function?

TextBox control source: =[Col1] & Tab(25) & [Col2] & Tab(50) & [Col3]
or
TextBox control source: =Print([Col1] & Tab(25) & [Col2] & Tab(50) & [Col3])

If a function is written in VB6, can it be used in Access?

Chuck