dbTalk Databases Forums  

Text formatting from a formula

comp.databases.filemaker comp.databases.filemaker


Discuss Text formatting from a formula in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steven Bitaxi
 
Posts: n/a

Default Text formatting from a formula - 09-13-2005 , 02:28 PM






I have a formula (which a few people on this group helped me with a
couple of months ago) that I want to add formatting to the text based
on certain conditions.

Case(
Get( CurrentDate) >= Date( Month(DateofHire)+3; Day(DateofHire);
Year(DateofHire) + 5); "Tenth Anniversary: " & GetAsText(Date(
Month(DateofHire); Day(DateofHire); Year(DateofHire) + 10));
Get( CurrentDate) >= Date( Month(DateofHire)+3; Day(DateofHire);
Year(DateofHire) + 3); "Fifth Anniversary: " & GetAsText(Date(
Month(DateofHire); Day(DateofHire); Year(DateofHire) + 5));
Get( CurrentDate) >= Date( Month(DateofHire)+3; Day(DateofHire);
Year(DateofHire) + 1); "Third Anniversary: " & GetAsText(Date(
Month(DateofHire); Day(DateofHire); Year(DateofHire) + 3));
Get( CurrentDate) >= Date( Month(DateofHire)+3; Day(DateofHire);
Year(DateofHire)); "First Anniversary: " & GetAsText(Date(
Month(DateofHire); Day(DateofHire); Year(DateofHire) + 1));
"Probationary")

The formula calculates the anniversaries of staff employed by our
organization. We would like to have the anniversary highlighted if it
is within the current month and year that the report is run to help as
a reminder.

So if they are celebrating 5 years here in September, the font would
appear bold and italic.

Can anyone offer suggestions for how I may accomplish this?


Reply With Quote
  #2  
Old   
Steven Bitaxi
 
Posts: n/a

Default Re: Text formatting from a formula - 09-13-2005 , 02:31 PM






Appending - FM7, WinXP SP2.


Reply With Quote
  #3  
Old   
FP
 
Posts: n/a

Default Re: Text formatting from a formula - 09-13-2005 , 04:40 PM



Create another calc field of type text and enter something like the
following:

If ( SomeTest ;
TextStyleAdd ( ExistingCalc ; bold ) ;
ExistingCalc )


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.