Re: Extra paragraph markers

On May 18, 11:39 pm, FastWolf <wolfsof...@xxxxxxxxx> wrote:
On Sat, 19 May 2007 11:10:39 +1200, Helpful Harry



<helpful_ha...@xxxxxxxxxxxxxxxx> wrote:
In article <134rh3uaoplh...@xxxxxxxxxxxxxxxxxx>, Howard Schlossberg
<how...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Scott in SoCal wrote:
On May 17, 9:25 pm, Helpful Harry <helpful_ha...@xxxxxxxxxxxxxxxx>
wrote:
You should also TRY to train the users to not put the extra return on
the end in the first place, but that's often like trying to teach a
fish not to swim. :o\

Don't forget about the return-to-leave-field feature. In layout mode,
right click the field and select Field/Control:Behavior (Ctrl+Alt+K)
and check Return Key next to under "Go to next object using".

Or use field validation to make the entry invalid if the last character
is a return (using the right() function) or if any character is a return
character (using the patterncount() function).

Or use the field's auto-entry calc function to always replace itself
with itself after the user exits the field, but stripping out any return
characters with the substitute() function.

Both of these are good ways in newer versions of FileMaker, but the
original person didn't say what version they were using - I always go
with the simplest solution that works no matter what version ...
besides, I don't have the newer versions so I don't know about those
new fangled ways. ;o)

Hey, if something works, why mess with it?

--
FW

Wow, thanks for all of the feedback. I use FM at my work, so I will
need to wait till I go back in next week to try out these solutions.
I wouldn't call myself a novice user, but definitely not advanced. It
looks like the return-to-leave-field feature might be the easiest.
Oh, and my work is using FM Pro v. 7, I believe. And yes, getting
people to stop putting the extra paragraph markers at the end of each
field IS like asking a fish not to swim ;)

Thanks again for the feedback. I'll let you know what works. thanks,
Tanya

.

Relevant Pages

  • Re: Extra paragraph markers
    ... fish not to swim. ... Or use field validation to make the entry invalid if the last character ...
    (comp.databases.filemaker)
  • Re: Extra paragraph markers
    ... fish not to swim. ... Or use field validation to make the entry invalid if the last character is a return function) or if any character is a return character function). ...
    (comp.databases.filemaker)
  • Re: Think dolphins are smart? Think again!
    ... ...Fish don't swim well out of water! ... the fish continued to swim badly or immediately die. ... "The reason the theory of evolution is so controversial is that it is the main scientific prop for scientific naturalism. ... So God is totally out of the picture, and humans are the accidental product of a purposeless universe. ...
    (talk.origins)
  • Re: KT boundry event
    ... Tiktaalik is not a fish. ... Is it too old to be an amphibian? ... You mean he's more closely related to tetrapods than are most fish you ... Pick a character and put the cutoff there, ...
    (talk.origins)
  • Re: Think dolphins are smart? Think again!
    ... Dolphins aren't fish. ... the fish continued to swim badly or immediately die. ... everything else) are the accidental product of a purposeless universe. ...
    (talk.origins)