Skip to Content
avatar image
Former Member

Can anyone get the parameter Edit mask '<' to work in 11.2

As I remember it, and the documentation seems to agree, By placing a '<' in an the parameter's edit mask, should cause the characters entered for the parameter to be converted to lower case. It is returning an error if the characters are not entered as lower case. I just want them converted.

I am trying to have parameter values in lowercase before evaluating them in selection criteria.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 03, 2008 at 02:10 PM

    Hi Janelle,

    The edit mask is working.

    The edit mask doesn't change the entered value. It restricts it to the value of

    the edit mask.

    You want to change what the user enters in a different location, like in a formula.

    If Not IsNull(?EnteredValue) and (?EnterValue) Not Equal "" Then

    LowerCase (?EnterValue) etc.

    Hope this helps,

    The Panda

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 08:22 PM

    Not sure of the 11.2 version you speak of but you can always use the LOWERCASE function in the record selection formula:

    lowercase ({?ParameterName}) = lowercase ()

    Add comment
    10|10000 characters needed characters exceeded