By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,492 Members | 1,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,492 IT Pros & Developers. It's quick & easy.

Problem with Trim command

P: n/a
For some reason this command will not trim the names shown in the
fields listed. I'm trying to do this in a text box on a report. I've
done this fairly succesfully in other reports but I must have done
something wrong here....
I've tried both of these...

=Trim([QGPL_BADGE1.OMLNAM] & [QGPL_BADGE1.OMFNAM])
=Trim([QGPL_BADGE1.OMLNAM] &", "& [QGPL_BADGE1.OMFNAM])

The fields are 25 character text fields.
Any ideas?

Nov 18 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
By your description, I'm assuming that when your textbox is displayed
it is coming out like Smith, John? What the Trim function is
going to do in your example is that it's going to put the last name and
first name together first and then trim it. What you need to do is
Trim both the LastName and FirstName so it looks like this:

=Trim([QGPL_BADGE1.OMLNAM]) & Trim([QGPL_BADGE1.OMFNAM])

Try that.

FlyerN87 wrote:
For some reason this command will not trim the names shown in the
fields listed. I'm trying to do this in a text box on a report. I've
done this fairly succesfully in other reports but I must have done
something wrong here....
I've tried both of these...

=Trim([QGPL_BADGE1.OMLNAM] & [QGPL_BADGE1.OMFNAM])
=Trim([QGPL_BADGE1.OMLNAM] &", "& [QGPL_BADGE1.OMFNAM])

The fields are 25 character text fields.
Any ideas?


Nov 18 '05 #2

P: n/a
Thanks, That did the trick!

Nov 18 '05 #3

P: n/a
Uh - I assume there should still be -one- space between the names...

=Trim([QGPL_BADGE1.OMLNAM]) & ' ' & Trim([QGPL_BADGE1.OMFNAM])

By the way, who chose those field names? They're abominable.

On 18 Nov 2005 07:53:28 -0800, jl*******@hotmail.com wrote:
By your description, I'm assuming that when your textbox is displayed
it is coming out like Smith, John? What the Trim function is
going to do in your example is that it's going to put the last name and
first name together first and then trim it. What you need to do is
Trim both the LastName and FirstName so it looks like this:

=Trim([QGPL_BADGE1.OMLNAM]) & Trim([QGPL_BADGE1.OMFNAM])

Try that.

FlyerN87 wrote:
For some reason this command will not trim the names shown in the
fields listed. I'm trying to do this in a text box on a report. I've
done this fairly succesfully in other reports but I must have done
something wrong here....
I've tried both of these...

=Trim([QGPL_BADGE1.OMLNAM] & [QGPL_BADGE1.OMFNAM])
=Trim([QGPL_BADGE1.OMLNAM] &", "& [QGPL_BADGE1.OMFNAM])

The fields are 25 character text fields.
Any ideas?


Nov 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.