L
LilC via AccessMonster.com
I have a report which looks like a legal pad with lines. 24 actual spaces.
The number of lines can not change. I have duplicated a form from Excel to
eliminate using it altogether. So it looks just like the Excel Report. I
coded the lines into the report. I am using a text box with data type set to
memo. I have several issues.
1. If the data entered into the textbox from my form fits in to the text box
on one line, then there is no problem. I can just move the page footer to
more or less the right position to allow it to fit inside the coded lines.
(It is not exact, but close)
2. If the data entered into the textbox from my form is longer than my text
box in the report, I need it to wrap (the textbox property is set to can grow)
, but I need it to stay inside the coded lines to be evenly distributed.
3. If the data entered into the textbox from my form takes up an entire page,
I need it to be able to fit into all the lines so it is evenly distributed
and dump the data onto the second page if necessary.
4. Then if I have a combination of 1, 2, or 3 above it creates more issues.
Basically, I can't seem to distribute the text evenly within the lines for
all the given situations.
My report has a subreport which is where I have the textbox/memo field. I
also have an electronic signature pad which is tied to a control. I need the
actual control to be concatenated with the textbox so it appears at the end
of the text if it fits in the textbox or if it doesn't fit, to be placed on
the very next line with it set to the right even with the textbox.
I've tried the textbox font underline property, but I don't think it's a good
idea here, because I have other text boxes. I've also tried the line spacing
property, but can't seem to get an exact number to satisfy all the situations.
Is there a way to code my textbox along with my lines so they are tied
together and are distributed evenly or am I just way off?
The number of lines can not change. I have duplicated a form from Excel to
eliminate using it altogether. So it looks just like the Excel Report. I
coded the lines into the report. I am using a text box with data type set to
memo. I have several issues.
1. If the data entered into the textbox from my form fits in to the text box
on one line, then there is no problem. I can just move the page footer to
more or less the right position to allow it to fit inside the coded lines.
(It is not exact, but close)
2. If the data entered into the textbox from my form is longer than my text
box in the report, I need it to wrap (the textbox property is set to can grow)
, but I need it to stay inside the coded lines to be evenly distributed.
3. If the data entered into the textbox from my form takes up an entire page,
I need it to be able to fit into all the lines so it is evenly distributed
and dump the data onto the second page if necessary.
4. Then if I have a combination of 1, 2, or 3 above it creates more issues.
Basically, I can't seem to distribute the text evenly within the lines for
all the given situations.
My report has a subreport which is where I have the textbox/memo field. I
also have an electronic signature pad which is tied to a control. I need the
actual control to be concatenated with the textbox so it appears at the end
of the text if it fits in the textbox or if it doesn't fit, to be placed on
the very next line with it set to the right even with the textbox.
I've tried the textbox font underline property, but I don't think it's a good
idea here, because I have other text boxes. I've also tried the line spacing
property, but can't seem to get an exact number to satisfy all the situations.
Is there a way to code my textbox along with my lines so they are tied
together and are distributed evenly or am I just way off?