Perhaps the leading character is not really a space? Other characters such as a tab will look like a space but will not be trimmed.
You can use the code functions on the first character and see if it returns 32, the code for the space character, or some other value to see if this might be the case.
That is true...the code function returns 160..how can I delete this?
Trim ( Substitute ( field ; Char ( 160 ) ; "" ) )
Will remove all instances of this character from your field and then trim any spaces.
ok..I did the exact calculation and show it as a text result in another field and it works..However, when I try to use it in my calculation field with the exact function, it doesn't work. If I delete the character 160 manually from the field, it does work..is there something I'm missing?
You should be able to use:
If (Exact(Trim ( Substitute ( field ; Char ( 160 ) ; "" ) );Trim ( Substitute ( field2 ; Char ( 160 ) ; "" ) )); "match", "not match")
I don't know which field had the invisible leading character, so I put the same fuctions in place for both fields.