[Maced] copy paste text into filemaker 6

stokesg at tpg.com.au stokesg at tpg.com.au
Sat May 31 11:42:26 EST 2008


If you don't need an immediate fix, you could do a replace script that
replaces the contents of fleld x with the contents of field x .. ie a
calcualtion replace, on closing the file:
select all records
replace fiedl with calcualtion
does this make sense?


Quoting Adam van Raad <adamvr at tpg.com.au>:

> thanks everyone, the Cmd-opt-v is probably the easiest, I'm sure I  
> will have to explain it about 1000 times but it works perfectly.
> 
> Regards
> Adam
> 
> 
> 
> 
> On 30/05/2008, at 10:27 PM, Murray Benn wrote:
> 
> > Hi Adam, Matt,
> >
> > Much simpler is to paste with the option key held down - Cmd-opt- 
> > v.   This pastes 'without style' stripping all the formatting.
> >
> > If the data is already there, as you have said, create a  
> > calculation field = to the original field that contains the text.  
> 
> > One of the limitations (or strengths in this scenario) of FileMaker
>  
> > 6 is that a calculated field cannot contain formatting.  Put this 
> 
> > field on the print layout instead of the data entry field, and you 
> 
> > should get your default formatting.
> >
> > Note that the current versions of FileMaker will retain formatting 
> 
> > in a calculated field, so you have to take steps to strip the  
> > formatting to achieve the same result.
> >
> > Hope that helps.  Regards,
> > -- 
> > Murray Benn
> > Managing Director
> > Denbigh International Pty Ltd
> > A FileMaker Business Alliance - Platinum Member
> > PO Box 3166   Narellan   2567
> > Ph:  (02) 4647 1375
> > Fax: (02) 4647 3410
> > e-mail: mbenn at denbigh.com.au
> > www:  http://www.denbigh.com.au
> >
> >
> >
> > On 30/05/2008, at 9:43 PM, Matt Darby wrote:
> >
> >> HI Adam ..
> >>
> >> First of all not sure if this will work in FMP 6 (Its been a  
> >> while ...) but you can try this .
> >>
> >> When you paste the text into the FileMaker field, immediately  
> >> press Command-Z. Command-Z is typically used to undo something,  
> >> and you'd think that doing this after pasting text into a field  
> >> would undo the paste operation. But that's not what it does in  
> >> this case. Instead, it leaves the pasted text in the field, but  
> >> removes the formatting for you (Note that pressing Command-Z a  
> >> second time will undo the paste altogether!)
> >>
> >> this will leave you with unformatted text in the field. Then the 
> 
> >> 'style; you apply on the report layout will work.
> >>
> >> however this may be a little difficult for staff to do...?
> >>
> >>
> >> Unfortunately as you said - no script steps available to to this -
>  
> >> you would need to move to FMP v7 or higher - then you could use a 
> 
> >> custom function to automate this.
> >>
> >> thanks ,
> >>
> >> ------------------------------------------------------
> >> Matt Darby
> >> Information Systems Manager
> >> Kambala
> >>
> >> (m) 0407 225 668
> >> (w) +61 2 9388 6703
> >> matt at kambala.nsw.edu.au
> >> www.kambala.nsw.edu.au
> >> ------------------------------------------------------
> >> iChat - mattdarby at mac.com
> >> Skype: mattdarby (http://www.skype.com)
> >>
> >> ------------------------------------------------------
> >>
> >>
> >>
> >> On 30/05/2008, at 9:32 PM, Adam van Raad wrote:
> >>
> >> Hi Everyone,
> >>
> >> I am having trouble trying to format text that has been pasted  
> >> into a field in FM6. It takes on the style (font etc) of the  
> >> original document but I want it to be a particular size, font etc 
> 
> >> to fit into a comment box on a report. Is there a way to do this? 
> 
> >> I have the layout set up so it has a particular font and size but 
> 
> >> it just gets ignored when teachers paste comments from another  
> >> file (usually word). I thought I could use a script to set the  
> >> font but there does net seem to be any commands to do this...
> >>
> >>
> >> Thanks
> >> Adam van Raad
> >>
> >> _______________________________________________
> >> Maced mailing list
> >> Maced at zeus.as.edu.au
> >> http://zeus.as.edu.au/mailman/listinfo/maced
> >>
> >>
> >> _______________________________________________
> >> Maced mailing list
> >> Maced at zeus.as.edu.au
> >> http://zeus.as.edu.au/mailman/listinfo/maced
> >>
> >> !DSPAM:483fe810101635209328925!
> >>
> >>
> >
> > _______________________________________________
> > Maced mailing list
> > Maced at zeus.as.edu.au
> > http://zeus.as.edu.au/mailman/listinfo/maced
> 
> 




More information about the Maced mailing list