dbTalk Databases Forums  

Using Let script to change font, pt size and style

comp.databases.filemaker comp.databases.filemaker


Discuss Using Let script to change font, pt size and style in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AL Lawrance
 
Posts: n/a

Default Using Let script to change font, pt size and style - 12-31-2006 , 10:46 AM






Can anyone provide me with an example of the LET function to change a TEXT
field's FONT, PT SIZE and STYLE all in one calculation.

Please use Surname as the text field in the LET calculation. Thanks in
advance for the help.

Al Lawrance.




Reply With Quote
  #2  
Old   
Howard Schlossberg
 
Posts: n/a

Default Re: Using Let script to change font, pt size and style - 12-31-2006 , 02:07 PM






Not sure why you'd use a Let function. In fact, you can't change fields
with Let -- only variables.

Use the Set Field script step to make the change, or else just use a
calc field, something like:

TextStyleAdd(TextSize(TextFont(Surname; Arial); 18); bold+underline)

I suppose you could turn it into a text function if you want to provide
for measier maintenance of the calc, something like:

Let([
x = Surname;
x = TextFont(x; Arial);
x = TextSize(x; 18);
x = TextStyleAdd(x, bold+underline) ];

x)



AL Lawrance wrote:
Quote:
Can anyone provide me with an example of the LET function to change a TEXT
field's FONT, PT SIZE and STYLE all in one calculation.

Please use Surname as the text field in the LET calculation. Thanks in
advance for the help.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles


Reply With Quote
  #3  
Old   
AL Lawrance
 
Posts: n/a

Default Re: Using Let script to change font, pt size and style - 12-31-2006 , 02:19 PM



Thanks, Howard.........

For now, I am going to try out the first suggestion you made.

Have a Happy New Year

Al Lawrance.


"Howard Schlossberg" <howard (AT) antispahm (DOT) fmprosolutions.com> wrote

Quote:
Not sure why you'd use a Let function. In fact, you can't change fields
with Let -- only variables.

Use the Set Field script step to make the change, or else just use a calc
field, something like:

TextStyleAdd(TextSize(TextFont(Surname; Arial); 18); bold+underline)

I suppose you could turn it into a text function if you want to provide
for measier maintenance of the calc, something like:

Let([
x = Surname;
x = TextFont(x; Arial);
x = TextSize(x; 18);
x = TextStyleAdd(x, bold+underline) ];

x)



AL Lawrance wrote:
Can anyone provide me with an example of the LET function to change a
TEXT field's FONT, PT SIZE and STYLE all in one calculation.

Please use Surname as the text field in the LET calculation. Thanks in
advance for the help.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles



Reply With Quote
  #4  
Old   
Howard Schlossberg
 
Posts: n/a

Default Re: Using Let script to change font, pt size and style - 12-31-2006 , 03:44 PM



One mistake: the font name should be in quotes.

AL Lawrance wrote:
Quote:
Thanks, Howard.........

For now, I am going to try out the first suggestion you made.

Have a Happy New Year

Al Lawrance.


"Howard Schlossberg" <howard (AT) antispahm (DOT) fmprosolutions.com> wrote in message
news:12pg63vn91dps6e (AT) corp (DOT) supernews.com...
Not sure why you'd use a Let function. In fact, you can't change fields
with Let -- only variables.

Use the Set Field script step to make the change, or else just use a calc
field, something like:

TextStyleAdd(TextSize(TextFont(Surname; Arial); 18); bold+underline)

I suppose you could turn it into a text function if you want to provide
for measier maintenance of the calc, something like:

Let([
x = Surname;
x = TextFont(x; Arial);
x = TextSize(x; 18);
x = TextStyleAdd(x, bold+underline) ];

x)



AL Lawrance wrote:
Can anyone provide me with an example of the LET function to change a
TEXT field's FONT, PT SIZE and STYLE all in one calculation.

Please use Surname as the text field in the LET calculation. Thanks in
advance for the help.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance


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.