Solved

Button Name Label Change Formula Anomoly

Posted on 2007-12-04
3
443 Views
Last Modified: 2013-12-18
Great Strange Question for everyone.
I have a formula for a button so that based upon a DBlookup, the button name changes each time it's pushed based upon the return value of the prior push.  Here is the name label formula.
key := CMsub_sys + "PkgApprovals" + @Middle(CMpkgID;2;2) + CMpkg_status;
@DbLookup(""; ""; "CMapprovals";key; "CMstat_to")

The problem is.  The return values can have a value like  CM_APPROVAL (with the underscore).  When the button is displayed the name that appears is CMAPPROVAL no underscore.  However in the actual lookup and the view and the value in the form that creates the view the underscore is there as part of the fields actual value.
Why is the underscore being removed in the button name display ???
Real strange.
Thank you
Paul
0
Comment
Question by:pratigan
3 Comments
 
LVL 22

Accepted Solution

by:
Bill-Hanson earned 250 total points
ID: 20406508
Underscore is a special character in several development environments when dealing with menu items and buttons.  Normally, you add an underscore before the letter that will be used as a hotkey for the action.  For example, if you were adding an "Edit" item for a menu (or button), you would probably name it "_Edit" so that the users could press ALT+E to activate the item.

To retain the underscore as part of the label, just double it using @ReplaceSubstring.
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 20408906
Hit the nail on the head.  Notes uses underscore as part of form names, agent names, etc., to indicate that the following letter is an accelerator for the menu.  Agents work that way in the ACTION menu.  The Action menu consists of the following elements:

1) Fixed, context-sensitive elements that are controlled by Notes itself, not the template. For example, whena document is highlighted, tghe LOCK DOCUMENT item on the action menu is automatic.

2) All agents in the tenplate

3) All ACTION BUTTONS in a view, form, or subform

Because of item #3, Notes wants to offer the developer an option to specify the accelerator key for the action name. So, wherever you place the first underscore in the name, it is not interpreted as an underscore to be displayed in the name, but as an indicator that the next letter following should be underlined in the menu, and treated as a hotkey within that menu.

Note that you can't change this behavior even if you elect for the action to be treated ONLY as a BUTTON and NOT on the action menu.

The seocnd as subsequent underscores are not given special treatment, so Bill's advice will work. I'm only epxlaining why this is so.
0
 
LVL 4

Author Comment

by:pratigan
ID: 20411742
Hello Bill,
Your absolutely correct.  I did some further testing yesterday after posting the question and I worked with different special characters and I found the resultant to be exactly what you explained.  I have already incorporated the doubling of the underscore which resolved the issue.
Thank You both for your feedback !!
Happy Holidays !!
Paul
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Lotus Domino Server Failure 1 176
Combine textlist text elements in Lotus Notes ReadViewEntries 3 121
Lotus Notes Database "Invalid NSF Version" 5 1,793
Domino Website - Redirection 12 54
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now