Field size in reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

setabery@hotmail.com - 31 Jan 2007 15:20 GMT

I have seen printed reports where the field size on the report does
not have enough space to print the value in the field. The first part
of the value in the field is printed and then an ellipis (...) is
inserted indicating that there is more but not enough room to print
it. Can this be done in Access and if so, how?

Reply to this Message

Tom Lake - 31 Jan 2007 15:31 GMT

>I have seen printed reports where the field size on the report does
> not have enough space to print the value in the field. The first part
> of the value in the field is printed and then an ellipis (...) is
> inserted indicating that there is more but not enough room to print
> it. Can this be done in Access and if so, how?

Determine the max characters you'd like to show and call that number M
(I use the dummy name Myfield. Replace that with your own field name)

Make the source of the text box be this:

=IIf(Len([Myfield]) > M, Left([Myfield], Len([Myfield]) - M - 5) & "(...)",
[Myfield])

Tom Lake

Reply to this Message

Marshall Barton - 31 Jan 2007 19:34 GMT

Gee, that makes a lot more sense than how I read the
question.

Note that proportional fonts can make the Len function near
useless when a close fit is needed. For a more precise
measurement of the length of a formatted text string, use
the TextWidthHeight function at www.lebans.com

Signature

Marsh
MVP [MS Access]

>>I have seen printed reports where the field size on the report does
>> not have enough space to print the value in the field. The first part
[quoted text clipped - 9 lines]
>=IIf(Len([Myfield]) > M, Left([Myfield], Len([Myfield]) - M - 5) & "(...)",
>[Myfield])

Reply to this Message

Marshall Barton - 31 Jan 2007 15:36 GMT

>I have seen printed reports where the field size on the report does
>not have enough space to print the value in the field. The first part
>of the value in the field is printed and then an ellipis (...) is
>inserted indicating that there is more but not enough room to print
>it. Can this be done in Access and if so, how?

Not sure what you're talking about, but if you are using a
text box control to display the value, then just open the
report in design view and change the text box's Width to
whatever size you want.

Signature

Marsh
MVP [MS Access]

Reply to this Message