Sign in to follow this  
Followers 0
madman411

Get(AccountName)

6 posts in this topic

I'm trying to set one of my custom menus' label to be the Account Name, however I want this to appear in Uppercase, or possibly even title case if I decide. I've tried using TextStyleAdd ( get ( accountname ) ; Uppercase ) however it doesn't do anything, leading me to believe custom menus can't have styles added to them, which I suppose makes sense. I've also tried creating a new global field and applying the style to that field and using that field as the title override for the menu - nada.

Any ideas on making this work?

Share this post


Link to post
Share on other sites

Upper( Get( AccountName ))

1 person likes this

Share this post


Link to post
Share on other sites
4 hours ago, madman411 said:

leading me to believe custom menus can't have styles added to them

I believe you are right: only layout objects can have/display a text style.

 

4 hours ago, madman411 said:

I want this to appear in Uppercase, or possibly even title case if I decide.

Use the Upper() function, or possibly even the Proper() function if you decide.

1 person likes this

Share this post


Link to post
Share on other sites

Works a treat.

I would've initially thought that Upper() and Proper() are essentially text style/formatting functions as well? Needless to say, it's exactly what I needed.

Share this post


Link to post
Share on other sites
1 hour ago, madman411 said:

I would've initially thought that Upper() and Proper() are essentially text style/formatting functions as well?

No, they are not. They actually modify the underlying text, not just apply style to it. Compare these:

Code ( "a" )

returns: 97

Code ( "A" )

returns: 65

Code ( Upper ( "a" ) )

returns: 65 (same as "A")

Code ( TextStyleAdd ( "a" ; Uppercase ) )

returns: 97 (same as "a").

 

You will notice the same difference if you export a calculation field using Upper(), compared to a calculation field using TextStyleAdd(). The former will be in upper case, the latter will retain the original case as entered.

2 people like this

Share this post


Link to post
Share on other sites

Thanks for clarifying, comment. Thinking back, this type of text modification within FM is something I've tried to suss out for a while but it seems I've been looking in the wrong place - the Text Formatting function list within the calculation engine.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0