Syntax Error

[FlaglerMuseum]

I keep getting a Syntax Error in my form, below is the formula I am using and I have been over it a hundred times and I cannot see what I am doing wrong. I also used the formula on another form and it works just fine but it is a different table. I have re-built the table because I'm told that it's probably the table but I still have a problem. Are their restrictions on the length of calculated fields? Any ideas as to what I could be doing wrong?

[:WORK:Current Membership Files\Database\Main Member Database.Title]+" "+[:WORK:Current Membership Files\Database\Main Member Database.First Name]+" "+Iif([:WORK:Current Membership Files\Database\Main Member Database.Middle Name]<>"",[:WORK:Current Membership Files\Database\Main Member Database.Middle Name],"")+" "+[:WORK:Current Membership Files\Database\Main Member Database.Last Name]+[:WORK:Current Membership Files\Database\Main Member Database."Jr. Sr. Etc"]+" "+Iif([:WORK:Current Membership Files\Database\Main Member Database.Partner Letter]="&",[:WORK:Current Membership Files\Database\Main Member Database.Partner Letter]+" "+[:WORK:Current Membership Files\Database\Main Member Database.Partner First Name]+" "+Iif([:WORK:Current Membership Files\Database\Main Member Database.Partner Middle Name]<>"",[:WORK:Current Membership Files\Database\Main Member Database.Partner Middle Name],"")+" "+[:WORK:Current Membership Files\Database\Main Member Database.Partner Last Name]+[:WORK:Current Membership Files\Database\Main Member Database."Partner Jr. Sr. Etc"],"")

 

[TonyMcGuire]

Try shortening the path to the files and see what happens.

Easiest would probably be to create an alias to 90% of that path length.

Tony McGuire
Stop Rob Bennett -

http://www.notrob.info

"It's not about having enough time; we have the rest of our lives. It's about priorities.