Hey All,

I'm running into a repeated problem with my databases. Not enough to make them useless, but this is an important problem that does cause our otherwise VERY helpful inventory tracking databases to fail occasionally.

I have relationships set up for various reasons; I need these relationships to be good, based on user-input info in different fields.

What is causing a problem is occasionally a user will hit "return" when entering sensitive text-based information. This invisible problem causes all the relationships to break that point at that record.

I know I can flip over to automatic entry key fields (such as a unique, numeric, unmodifiable recordid) to avoid this entirely, but for various reasons that is not attractive (though it is a last resort, if necessary)

What I would LOVE to know, is this: is there any way to search for return characters in text fields (as part of a cleanup script, perhaps), and/or to set a validation for data entry that would catch and prevent return characters from being entered?

Thanks in advance

You can use auto-enter calculation that replaces field value and use substitute ( text; "¶"; "" ) function. This checks for return characters and substitutes them with nothing.

HTH

Interesting.. how do I access that return character you show? And thank you, by the way.

It shows up as one of the 'operators' in the window that you go to when you check to auto enter a calculated value

Phil

all this time and I never noticed that. *smacks forehead*. Thank you both so much!