report question

  • Thread starter Thread starter Steve Goodrich
  • Start date Start date
S

Steve Goodrich

I have a form which includes a memo field, sometimes there is a lot of text
in the field ( half a page of a4) when i print or view a report I am only
getting approx 250 characters in the memo field on the report.

how do i set it up so i can view all my data or the field on the report
limited to 250 char.

many thanks
Steve
 
Hi Steve,

IIRC this can happen if the textbox displaying the field has a Format
property applied to it (e.g. ">"), or if you're using a VBA function in
the underlying query.
 
I did indeed have the format set to ">" is there another way to force the
text into upper case that will allow more than 255 char in the report? my
boss wants it this way!!
thanks for any help
Steve
 
There isn't a really simple way. These are the first methods that come
to mind:

1) Using the StrConv() function in an update query to convert the stored
text to uppercase so you don't need to use the format.
2) Using a temporary table: use an append query to copy the records to
the temporary table, converting to uppercase with StrConv() on the way.
Then export from the temporary table (again, with no format on the
field).
3) Persuade your boss that converting to upper case makes the text much
harder to read and that it's better to leave it as it is.

Of these, (3) is the best!



I did indeed have the format set to ">" is there another way to force the
text into upper case that will allow more than 255 char in the report? my
boss wants it this way!!
thanks for any help
Steve
Click to expand...
 
Thanks for your help John, option 3 does sound the easiest.
John Nurick said:
There isn't a really simple way. These are the first methods that come
to mind:

1) Using the StrConv() function in an update query to convert the stored
text to uppercase so you don't need to use the format.
2) Using a temporary table: use an append query to copy the records to
the temporary table, converting to uppercase with StrConv() on the way.
Then export from the temporary table (again, with no format on the
field).
3) Persuade your boss that converting to upper case makes the text much
harder to read and that it's better to leave it as it is.

Of these, (3) is the best!
Click to expand...
 
Back
Top