By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,306 Members | 1,657 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,306 IT Pros & Developers. It's quick & easy.

Word-like table in Access

P: n/a
Mo
I am trying to produce an Access report which behaves like a two
column table in Word. In other words each cell in column 1 contains a
label and each cell in column 2 contains data from a different text
field from a query and the cells expand or contract according to the
size of the text field.

I have tried "Can Shrink" but this leaves gaps and "Can Grow" but this
seems to cause the cells to overlap and then Access throws page breaks
in an unpredictable manner. Also "Can Shrink" and "Can Grow" do not
apply to labels, but I guess I can find a way round this.

Is there a solution to this? Otherwise, I think I will have to resort
to a fixed format, sizing the cells for what I estimate to be the
maximum field size.

Any ideas most gratefully received .

Apr 24 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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


Apr 25 '07 #2

P: n/a
"Mo" <ma**********@hotmail.comwrote in message
news:11**********************@s33g2000prh.googlegr oups.com...
>I am trying to produce an Access report which behaves like a two
column table in Word. In other words each cell in column 1 contains a
label and each cell in column 2 contains data from a different text
field from a query and the cells expand or contract according to the
size of the text field.

I have tried "Can Shrink" but this leaves gaps and "Can Grow" but this
seems to cause the cells to overlap and then Access throws page breaks
in an unpredictable manner. Also "Can Shrink" and "Can Grow" do not
apply to labels, but I guess I can find a way round this.

Is there a solution to this? Otherwise, I think I will have to resort
to a fixed format, sizing the cells for what I estimate to be the
maximum field size.

Any ideas most gratefully received .
Try using MailMerge to populate a Word document so you can format it in Word
as you want it.

Keith.
www.keithwilby.com
Apr 25 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.