"Mo" <ma**********@hotmail.comwrote
I am trying to produce an Access report which
behaves like a two column table in Word.
As you have discovered, Access is not Word.
Data for Word tables is entered manually or programmatically into the
Tables, and that is where it exists (with possible exceptions). And all the
adjacent cells in a Word table adjust together for height as the amount of
data changes.
Data in Access is stored in Tables and formatted, at execution time, for
display with Reports. The CanGrow and CanShrink properties are for
individual Controls, and for the Section in which those Controls reside.
And, as you have discovered, though they are "individual" to each TextBox
Control, those controls are affected by adjacent Controls, and may work in
unexpected ways if they touch each other.
And, it is not clear how the data is stored that you want to display. What
you describe could be for Fields within each Record, or it could be for
Records within the Database -- I'm assuming the data you want in the Label
Controls is identifying data for the adjacent data, but other than that,
don't know its source.
I am not certain there is a reliable way to do exactly what you want, but
unless we know what data you are trying to display and how it is stored, I'm
reasonably certain no one is going to be able to make any worthwhile
suggestions.
One suggestion that occurs to me is to use the excellent formatting features
that Access does provide, and not insist that the Reports be identical to
Word Tables. Another would be to use COM Automation to Control Word, and
create the "Report" with Word. If the data you want in the Tables is in
consecutive Records, perhaps using a Report embedded in a Subreport Control
would be useful.
Please clarify regarding the data, and where it is stored. Maybe someone can
be of help.
Larry Linson
Microsoft Access MVP