Hello,
I have a report based on a form with the text-box controls on both being
indentical. The controls on both the report and the form have the same table
as their control source. My problem is that when I update or other wise
change the text-box controls on the form the text doesn't appear on the
report in the same order. As an example, if on the form or in the table I
type:
1.Ministry of External Relations
2.Ministry of Defence
then on the report it appears as:
1.Ministry of External
Relations
2. Ministry of
Defence.
Thus far I've been unable to get the text to appear in the same
text-alignement on both the form and the report. I have the 'can grow' & 'can
shrink' properties for the text box controls on the reprt set to 'yes'. I
have also tried setting the Format properties 'height', 'width' and 'top' for
the text box controls on both the form and the report to indentical values
but with no effect.
I hope my explanation of my problem is clear enough....would anyone know how
I could get the text to appear with the same text-alignement on both the form
and the report?
Thanks in advance.
John Spencer - 02 Jan 2007 13:07 GMT
Are you typing
1.Ministry of External Relations 2.Ministry of Defence
ALL into one textbox and using spaces to make
2.Ministry of Defence
appear on a second line?
If so, instead of using spaces to get the second line try typing Control +
return(enter) to embed a new line sequence into the text box.
1.Ministry of External Relations <<<Control+return>>>2.Ministry of Defence
The next question is why are you putting two (or more) pieces of information
in one field? I suspect that you may really need to have an additional
table to hold this organization information, but without knowing you
structure I really don't know.
> Hello,
>
[quoted text clipped - 30 lines]
>
> Thanks in advance.