=Trim for a text field *help*

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

Guest

This is grabbing information from a multiselect text box.
=Trim(Mid([Filter],30))
This works great, but when the result is displayed on the report, the text
is trailing two end paranthesis ))
So it will read: 'Selection 1', 'Selection 2', 'Selection 3'))
I need to get rid of those, any ideas?

Thanks,
Jeff
 
You can use the replace function to remove it, but it wll remove the
paranthesis from the all text box

=replace (Trim(Mid([Filter],30)),")","")
 
When you say it will replace all the paranthesis, are you saying just in that
ONE textbox, or are you saying it will do that to ALL my textboxes on my
report?

Ofer said:
You can use the replace function to remove it, but it wll remove the
paranthesis from the all text box

=replace (Trim(Mid([Filter],30)),")","")

Jeffshex said:
This is grabbing information from a multiselect text box.
=Trim(Mid([Filter],30))
This works great, but when the result is displayed on the report, the text
is trailing two end paranthesis ))
So it will read: 'Selection 1', 'Selection 2', 'Selection 3'))
I need to get rid of those, any ideas?

Thanks,
Jeff
Click to expand...
Click to expand...
 
Only this text box, try it.

Jeffshex said:
When you say it will replace all the paranthesis, are you saying just in that
ONE textbox, or are you saying it will do that to ALL my textboxes on my
report?

Ofer said:
You can use the replace function to remove it, but it wll remove the
paranthesis from the all text box

=replace (Trim(Mid([Filter],30)),")","")

Jeffshex said:
This is grabbing information from a multiselect text box.
=Trim(Mid([Filter],30))
This works great, but when the result is displayed on the report, the text
is trailing two end paranthesis ))
So it will read: 'Selection 1', 'Selection 2', 'Selection 3'))
I need to get rid of those, any ideas?

Thanks,
Jeff
Click to expand...
Click to expand...
Click to expand...
 
Back
Top