The trim function gives me a compiler error

SortName: Trim([Members]![LastName] & ", " & [Members]![FirstName] & " " &
[Members]![MiddleName] & " " & [Members]![Suffix] & " " & [Members]![Title])

The function works using windowXP & vista

Any suggestions would be helpful.

In the VB window, type the following in the Immediate pane:

Debug.Print Trim(" 1 " )

If you get an error, then it's probably a References issue. Go up to Tools,
References and see if anything is amiss there.

If it does work, there may be something wrong with your SortName. Simplify
by removing some of the fields in it and see what works and doesn't work.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Als Hotmail" wrote:

> The trim function gives me a compiler error
>
> SortName: Trim([Members]![LastName] & ", " & [Members]![FirstName] & " " &
> [Members]![MiddleName] & " " & [Members]![Suffix] & " " & [Members]![Title])
>
> The function works using windowXP & vista
>
> Any suggestions would be helpful.
>

Debug.Print Trim(" 1 " ) works in the VB window.
When I put in a query grid sortname: trim(" 1 ") I get the error message
compile error in query.
Any other suggestions?
Thanks Al

"Jerry Whittle" <(E-Mail Removed)> wrote in message
news:4DE009EA-30D1-4FF5-AA0C-(E-Mail Removed)...
> In the VB window, type the following in the Immediate pane:
>
> Debug.Print Trim(" 1 " )
>
> If you get an error, then it's probably a References issue. Go up to
> Tools,
> References and see if anything is amiss there.
>
> If it does work, there may be something wrong with your SortName. Simplify
> by removing some of the fields in it and see what works and doesn't work.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Als Hotmail" wrote:
>
>> The trim function gives me a compiler error
>>
>> SortName: Trim([Members]![LastName] & ", " & [Members]![FirstName] & " "
>> &
>> [Members]![MiddleName] & " " & [Members]![Suffix] & " " &
>> [Members]![Title])
>>
>> The function works using windowXP & vista
>>
>> Any suggestions would be helpful.
>>

Thanks
Can you send me a copy of the code.
I am using Access 2007 in window 7
Thanks again Al


"Jerry Whittle" <(E-Mail Removed)> wrote in message
news:4DE009EA-30D1-4FF5-AA0C-(E-Mail Removed)...
> In the VB window, type the following in the Immediate pane:
>
> Debug.Print Trim(" 1 " )
>
> If you get an error, then it's probably a References issue. Go up to
> Tools,
> References and see if anything is amiss there.
>
> If it does work, there may be something wrong with your SortName. Simplify
> by removing some of the fields in it and see what works and doesn't work.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Als Hotmail" wrote:
>
>> The trim function gives me a compiler error
>>
>> SortName: Trim([Members]![LastName] & ", " & [Members]![FirstName] & " "
>> &
>> [Members]![MiddleName] & " " & [Members]![Suffix] & " " &
>> [Members]![Title])
>>
>> The function works using windowXP & vista
>>
>> Any suggestions would be helpful.
>>