validation calc help

[Neuronal Nerd]

My wife uses my solution, and she has an annoying habit of typing an extra space after every single entry to a field. I would like have the validation calculation give a message each time a user does this. I've tried the following, but it does not seem to do anything and I have always validate checked:

Left(My Field Name; 1) <> " "

Any ideas (besides marital counseling -)) ?

[Lee Smith]

why not just trim them out.

check out this Custom Function Link in the interest of peace in the family.

Lee

[comment]

Well, left is at the beginning of a field, not at the end. However, if you are interested in solving the problem rather trying to annoy your wife, I'd say forget about validation and make the field auto-enter a calculation (replacing existing value) =

Trim ( Self )

[Neuronal Nerd]

Thanks so much, I've never actually put to use the replace existing value feature. That is probably what I'll end up doing, but there is a devious side of me that cannot wait to annoy my wife. Maybe, I'll make the calculation user dependent and just give her the annoying message...Yeah, we definitely need counseling, or at least I do.

[comment]

Let me just clarify that when I said "replace existing", I was referring strictly to Filemaker issues.

[Neuronal Nerd]

LOL

[Lee Smith]

Isn't that what I said?