Put this calculation in the auto-enter option of that field:
Substitute ( TrimAll ( Self ; 1 ; 3 ) ; ")" ; ") " )
This will adjust every new record.
To adjust the old records, while in Browse Mode, place the cursor in that field and do a "Replace Field Contents" whith a calculation like this:
YourTable::YourField ( put the REAL field name there )
( practicaly that replaces the contents of that field with the above calculation )
ATTENCTION: do this operation in a copy of your DB, because it's not undoable )
i'll give it a shot. thank you so much. after weeks of mistakes, this is a welcome direction!!
BINGO. thank you all so much. FILEMAKER would not help me unless i went thru a big ordeal so this was really great.
FILEMAKER would not help me
But FileMaker just did help you. They created this forum so that questions of this type could be answered quite easily by fellow users.