multiple columns error...pls hlp

[marolb]

hi..apperciate any help..thx anywys...
i need to display the values of a field as columns instead of rows, so i
went to "page setup" and set the number of columns to 44.
it worked fine and the contents did fit on one page.
However, when i saved and tried to re-open the rpt, i got the following
error when i tried to display the results:
"2 errors occured when u loaded the form or report --
you loaded a form or report that has controls or properties that Microsoft
Access doesn't recognize and will ignore."
the report was reset to ONE column and data displayed in rows instead of
multiple columns.
if i define around 25 columns, it works fine...
BUT i need to define 44 columns.
is there a possibility to fix this ?!
thx
marwan

 

[Duane Hookom]

There is a limit to the number of columns support by Access reports. You
might be able to use the method found in the Multicolumn Demo at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

 

[marolb]

thx a lot, maybe i will use 2 subreports
however, is it possible to add fields (on main report) say on the right of
the subreport and make sure that they appear even though the subreport might
vary in Width?!
thx again.
marwan

 

[Duane Hookom]

You can move controls much easier than you can vary the width of a
subreport.

 

[marolb]

thx again
however, how can u move controls when u can't know wht is "width" of the
subreport. the subreport varies in width depending on the # of columns shown.
does this work?
can u get the # of fields multiply by the width of the field in subeport and
then draw the other controls on the right of subreport using line ft???!
thx
regards, marwan

 

[Duane Hookom]

Please take the time to use proper grammar. Find your shift key and type out
complete words. It's not that I am too old to understand, it's just that I
expect a certain amount of effort on your part.

How does your subreport end up with varying numbers of columns? Seems to me
the only way that this can be done is in design view. If so, why do you need
code to move anything on your main report?

 

[marolb]

First of all. I appreciate all your help.
Second, I was trying to use "short-cuts" for unimportant words, so that the
concentration would be on the problem I am facing.
Anyways, varying numbers of columns is due to the fact that I have specified
the number of columns in the page setup as 10.
So, the subreport contains one field which can span horizontally instead of
vertically depending on the records (minimum=1;maximum=10) in the source
query of the subreport.
This is where the problem arises:
Depending on the criteria in the main report, the number of records (1 to
10) in the subreport change. So, what happens, is that the subreport might
grow/shrink horizontally and not vertically, thus making it diffuclt to place
labels/fields on the Right of the subreport.
Finally, "Too old" is an obsolete concept. No one can be "too old". You will
stay young as long as you keep interacting with the universe around you. This
is my own persepective. We might disagree, but I thank you again for all your
help. regards.

 

[Duane Hookom]

So your subreport control on the main report does not actually shrink. The
number of columns displayed may be more or less depending on the number of
records in the subreport.

You should be able to find the number of records in the subreport and then
set the Left property of any controls on the main report that you want to
move.