Display Grid

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JerryA - 12 Mar 2008 15:15 GMT

I have this problem:
I have a grid with 31 columns as days and 12 rows as months. In some of the
“cells” will be letters (A, B, X …). One cell = 1 letter. These letters will
be uploads from users (by form).
I cannot use 365 fields for 365 cells (because there is limit 255), so I
have in tab a field with number (order of day) and in report (within this
tab) I have in every cell textbox with condition:
=IIf([order]=1;[OneLetter];Null), =IIf([order]=2;[OneLetter];Null) ,
=IIf([order]=3;[OneLetter];Null) … but report effect is no good, because
after every text box is line spacing.
X
A
B
I need
X A B

Thanks for any help.

Signature

Jerry

Reply to this Message

Marshall Barton - 12 Mar 2008 16:06 GMT

>I have this problem:
>I have a grid with 31 columns as days and 12 rows as months. In some of the
[quoted text clipped - 11 lines]
>I need
>X A B

You can have 754 controls in a form/report so you can have a
separate text box for each "cell".

However, that is a rather clumsy design. You should
investigate using a little table with 12 records as the
report's record source so the detail section would only need
31 text boxes. It may even be possible for you to arrange
the record source query so the report can use 31 columns
with only 1 text box in the detail section.

Signature

Marsh
MVP [MS Access]

Reply to this Message