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.

--
Jerry

JerryA wrote:

>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


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.

--
Marsh
MVP [MS Access]