Thread: I am using Window 7 and Access 2007
View Single Post
  #1  
Old May 19th, 2010, 08:43 PM posted to microsoft.public.access.gettingstarted
Als Hotmail
external usenet poster
  
Posts: 3
Default I am using Window 7 and Access 2007
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.