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 ???