Spaces

[teiben]

I have a table w/field set as text that I don't want users to enter a "space" into, how would I stop this? I suspect " " in the field validation field? Does this sould correct? What does everyone else use?

 

[namliam]

Use the "on key" event then trap the space

or use validation where not like "* *"

 

[teiben]

the on key, isn't that on the form?
not like "* *" is that in the table properties, or on the form?
Thank you

 

[namliam]

Not like "* *" is in the validation of the field in the form...

On key event is both on form and on object level.

 

[neileg]

Actually, Not Like "* *" will trap any entry that has a space in it. If what you want is to force a text entry of some sort but exclude a simple space on its own, then your suggestion of Not " " is the one to use.