Memo Text in Reports

  • Thread starter Thread starter Ron Dechiro
  • Start date Start date
R

Ron Dechiro

I am designing a report that has a control source with a
memo text property. I want the text to appear in the
report with all capital letters. When I add the format
change of ">" to the format section of the properties for
the control source the report returns the text in capital
letters, but all of the data is not there. It truncates
the data and doesn't show all the data. If I remove
the ">" all the data reappears in lower case. How do I
fix this problem?
 
I am designing a report that has a control source with a
memo text property. I want the text to appear in the
report with all capital letters. When I add the format
change of ">" to the format section of the properties for
the control source the report returns the text in capital
letters, but all of the data is not there. It truncates
the data and doesn't show all the data. If I remove
the ">" all the data reappears in lower case. How do I
fix this problem?
Click to expand...
Use an Unbound Control.
Set it's Control Source to:

=UCASE([MemoField])

Set the control and the Detail section CanGrow property to Yes.
 
-----Original Message-----
I am designing a report that has a control source with a
memo text property. I want the text to appear in the
report with all capital letters. When I add the format
change of ">" to the format section of the properties for
the control source the report returns the text in capital
letters, but all of the data is not there. It truncates
the data and doesn't show all the data. If I remove
the ">" all the data reappears in lower case. How do I
fix this problem?
Click to expand...
Use an Unbound Control.
Set it's Control Source to:

=UCASE([MemoField])

Set the control and the Detail section CanGrow property to Yes.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.
Fred, thank you for the quick reply. I did as you
Click to expand...
suggested and it did not work. I even removed the control
and then dragged a new control to the detailed section and
that did not work. I have both the Detail and Control
CanGrow property set to Yes. Do you have another
suggestion. Thanks in advance.
 
-----Original Message-----
I am designing a report that has a control source with a
memo text property. I want the text to appear in the
report with all capital letters. When I add the format
change of ">" to the format section of the properties for
the control source the report returns the text in capital
letters, but all of the data is not there. It truncates
the data and doesn't show all the data. If I remove
the ">" all the data reappears in lower case. How do I
fix this problem?
Click to expand...
Use an Unbound Control.
Set it's Control Source to:

=UCASE([MemoField])

Set the control and the Detail section CanGrow property to Yes.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.
Fred, thank you for the quick reply. I did as you
Click to expand...
suggested and it did not work. I even removed the control
and then dragged a new control to the detailed section and
that did not work. I have both the Detail and Control
CanGrow property set to Yes. Do you have another
suggestion. Thanks in advance.
Click to expand...

I worked fine for me.
Did you remove all formatting from the control?
Are you using a query as recordsource for this report?
If you are, check in the query itself, that you are returning more
than 255 characters.
The query can NOT be a Union or Group By query. Those types of
queries will truncate a memo field.
 
-----Original Message-----
-----Original Message-----
On Fri, 6 Feb 2004 07:52:03 -0800, "Ron Dechiro"

I am designing a report that has a control source with a
memo text property. I want the text to appear in the
report with all capital letters. When I add the format
change of ">" to the format section of the properties for
the control source the report returns the text in capital
letters, but all of the data is not there. It truncates
the data and doesn't show all the data. If I remove
the ">" all the data reappears in lower case. How do I
fix this problem?
Use an Unbound Control.
Set it's Control Source to:

=UCASE([MemoField])

Set the control and the Detail section CanGrow property to Yes.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.
Fred, thank you for the quick reply. I did as you
Click to expand...
suggested and it did not work. I even removed the control
and then dragged a new control to the detailed section and
that did not work. I have both the Detail and Control
CanGrow property set to Yes. Do you have another
suggestion. Thanks in advance.
Click to expand...

I worked fine for me.
Did you remove all formatting from the control?
Are you using a query as recordsource for this report?
If you are, check in the query itself, that you are returning more
than 255 characters.
The query can NOT be a Union or Group By query. Those types of
queries will truncate a memo field.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.
How do you remove all formatting from the control? I am
Click to expand...
not sure what you mean by this. The record source is a
query. All of the text appears in the query and it will
appear on the report in lower case, but not in upper
case. If I remove the format property ">" the report will
show all the text in lower case. I want it in upper
case. Is there another way to achieve uppercase in the
report? As far as I know the query is not a Union or
Group Query. It is a basic query from a table. Please
excuse if my terminology is not correct as I am new to
ACCESS.
Thanks....
 
-----Original Message-----
-----Original Message-----
On Fri, 6 Feb 2004 07:52:03 -0800, "Ron Dechiro"

I am designing a report that has a control source with a
memo text property. I want the text to appear in the
report with all capital letters. When I add the format
change of ">" to the format section of the properties
for
the control source the report returns the text in
capital
letters, but all of the data is not there. It truncates
the data and doesn't show all the data. If I remove
the ">" all the data reappears in lower case. How do I
fix this problem?
Use an Unbound Control.
Set it's Control Source to:

=UCASE([MemoField])

Set the control and the Detail section CanGrow property
to Yes.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.
Fred, thank you for the quick reply. I did as you
suggested and it did not work. I even removed the control
and then dragged a new control to the detailed section and
that did not work. I have both the Detail and Control
CanGrow property set to Yes. Do you have another
suggestion. Thanks in advance.
Click to expand...

I worked fine for me.
Did you remove all formatting from the control?
Are you using a query as recordsource for this report?
If you are, check in the query itself, that you are returning more
than 255 characters.
The query can NOT be a Union or Group By query. Those types of
queries will truncate a memo field.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.
How do you remove all formatting from the control? I am
Click to expand...
not sure what you mean by this. The record source is a
query. All of the text appears in the query and it will
appear on the report in lower case, but not in upper
case. If I remove the format property ">" the report will
show all the text in lower case. I want it in upper
case. Is there another way to achieve uppercase in the
report? As far as I know the query is not a Union or
Group Query. It is a basic query from a table. Please
excuse if my terminology is not correct as I am new to
ACCESS.
Thanks....
Click to expand...

You remove formatting from a control by removing the > (and
aeverything else) from it's format property. It should be blank.

My suggestion to use =UCase([FieldName]) was to use it in a control in
the report itself, not in the query.

If you are not sure of the type of query you have, post the query SQL.
 
-----Original Message-----
-----Original Message-----
On Fri, 6 Feb 2004 10:59:22 -0800, "Ron Dechiro"


-----Original Message-----
On Fri, 6 Feb 2004 07:52:03 -0800, "Ron Dechiro"

I am designing a report that has a control source
Click to expand...
with
a
memo text property. I want the text to appear in the
report with all capital letters. When I add the format
change of ">" to the format section of the properties
for
the control source the report returns the text in
capital
letters, but all of the data is not there. It truncates
the data and doesn't show all the data. If I remove
the ">" all the data reappears in lower case. How
Click to expand...
do
I
fix this problem?
Use an Unbound Control.
Set it's Control Source to:

=UCASE([MemoField])

Set the control and the Detail section CanGrow property
to Yes.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.
Fred, thank you for the quick reply. I did as you
suggested and it did not work. I even removed the control
and then dragged a new control to the detailed section and
that did not work. I have both the Detail and Control
CanGrow property set to Yes. Do you have another
suggestion. Thanks in advance.

I worked fine for me.
Did you remove all formatting from the control?
Are you using a query as recordsource for this report?
If you are, check in the query itself, that you are returning more
than 255 characters.
The query can NOT be a Union or Group By query. Those types of
queries will truncate a memo field.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
.
How do you remove all formatting from the control? I
Click to expand...
am
not sure what you mean by this. The record source is a
query. All of the text appears in the query and it will
appear on the report in lower case, but not in upper
case. If I remove the format property ">" the report will
show all the text in lower case. I want it in upper
case. Is there another way to achieve uppercase in the
report? As far as I know the query is not a Union or
Group Query. It is a basic query from a table. Please
excuse if my terminology is not correct as I am new to
ACCESS.
Thanks....
Click to expand...

You remove formatting from a control by removing the > (and
aeverything else) from it's format property. It should be blank.

My suggestion to use =UCase([FieldName]) was to use it in a control in
the report itself, not in the query.

If you are not sure of the type of query you have, post the query SQL.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
I removed the ">" from the format property on the control
Click to expand...
on the report and entered =UCase([Comments]) into the
control source on the report and the report returned
#Error on the report itself. How do I post the query SQL?
Thanks....
 
Back
Top