=Trim for a text field *help*

J

Jeffshex

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
 
O

Ofer

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)),")","")
 
J

Jeffshex

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...
 
O

Ofer

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...
 
Top