Limiting Field Length in report

  • Thread starter Thread starter jennifer
  • Start date Start date
J

jennifer

I have a report with some fields that I need to limit to
30 characters each (so that only 30 characters are
displayed).

In the report design view, I am rt. clicking on the
field, then selecting "Properties". In the control source
field, I am opening the expression builder and entering
the expression =Left([address],30).

I have about 5 fields that I need to limit-- one of them
is working, the others are not (when I run the report, I
get #Error in some of the fields).

IS there a trick to getting this to work, or is there
another function or some other way of only printing the
first 30 characters?

Thanks!!
 
jennifer said:
I have a report with some fields that I need to limit to
30 characters each (so that only 30 characters are
displayed).

In the report design view, I am rt. clicking on the
field, then selecting "Properties". In the control source
field, I am opening the expression builder and entering
the expression =Left([address],30).

I have about 5 fields that I need to limit-- one of them
is working, the others are not (when I run the report, I
get #Error in some of the fields).

IS there a trick to getting this to work, or is there
another function or some other way of only printing the
first 30 characters?
Click to expand...

What you posted should normally work. I'll take a stab in
the dark here and guess that the text boxes that don't work
have the same name as the field it's trying to trim. In
other words
=Left([address],30)
will generate #Error if the text box is named address. Just
change it to something else such as txtAddress.
 
Back
Top