truncate letter

[Joel]

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.

 

[Ken Snell [MVP]]

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.

 

[Joel]

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

 

[Ken Snell [MVP]]

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>

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

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.