truncate letter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to truncate the any white space in the field when printed. I've tried
to use the =trim([field name]) but I keep getting an error instead of the
data in the field.
 
Which error do you get? Is the textbox named the same as the field name? If
yes, change the name of the textbox to something else, as having a textbox
with the same name as a field when the textbox is not bound to the field
will greatly confuse ACCESS because it isn't sure which one you want to use.
 
I changed the name of the text box and I don't get the word ERROR but it
doesn't truncate the spaces on either end of the words.

I used =Trim([field])

I'm using the same trim function in another report and it works fine. Not
sure what to try next.

thanks
 
When you change the textbox name in these situations, sometimes the
expression will also change to the textbox's name. Check that it shows the
correct field name.

Is there a carriage return and line feed in the text? Trim won't eliminate
blank spaces between the end of text and those characters.

--

Ken Snell
<MS ACCESS MVP>


Joel said:
I changed the name of the text box and I don't get the word ERROR but it
doesn't truncate the spaces on either end of the words.

I used =Trim([field])

I'm using the same trim function in another report and it works fine. Not
sure what to try next.

thanks

Joel said:
I want to truncate the any white space in the field when printed. I've
tried
to use the =trim([field name]) but I keep getting an error instead of the
data in the field.
Click to expand...
Click to expand...
 
Back
Top