=Trim for a text field *help*

[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

 

[Guest]

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

 

[Guest]

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?

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

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

 

[Guest]

Only this text box, try it.

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?

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

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