Jump to content

spaces and tabs not allowed


This topic is 5749 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5749 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.