spaces and tabs not allowed

[Joel Saltzman]

Is it possible to prevent a user from being able to enter spaces or tables into a field?

[Lee Smith]

You mean beside rapping them on their knuckles when you catch them.

You are using v8, so you can have an Auto Enter calculation to remove them after the fact.

select the Text Field involved, and the click on the options. Under Auto Enter, Select "Calculated Value", and enter a calculation something like:

Substitute ( Text ; [" " ; " "]; [" "; " "] )

Click Okay, and then deselect the option "Do not replace existing value (if any).

(i.e. Substitute ( Text ; ["**" ; "*"]; ["tab"; "*"] ) [color:blue]* equals a space You can expand this to include other things like triple spaces, double paragraphs, etc.

HTH

Lee

[Joel Saltzman]

LOL, that would be a great fix for many problems.

So simple.... What a great idea. I didnt take into consideration that when they are entering new line items, I could set it up to do that. THANKS!

[Stuart Taylor]

Hi Lee,

This would make a great custom function.

Wonder how much you would have to include.

AutoCorrect ( Text )

or to refine

AutoCorrect ( Text ; Returns ; Spaces ; ...etc )

Return 1 or 0 to include / exclude

[Stuart Taylor]

AutoCorrect ( Text )

Let ( Text =

Substitute (

Substitute (

Text

; " " ; " " )

; "¶¶" ; "¶" )

;

Case ( Right ( Text ; 1 ) = "¶" ; Left ( Text ; Length ( Text ) -1 ) ; Text )

)

Something like this ... not sure i am happy with all of its behavior ... + i would probably just allow tabbing to the next field/object to avoid accidental tabs and include enter/return if i did not wish any carrage returns at all.