Remove Dotted Line for Text Prompt

[bvacha]

Hi,

Has anyone figured out a way to remove the red dotted line that appears below a non-required text prompt?  I've seen posts for how to do this through javascript for value prompts, but not for text prompts.

Thanks,
Brian

[rprameshwor]

Have you tried  setting the following properties for the prompt :

Required : No
Hide Adorments : Yes

[bvacha]

Thanks rprameshwor,

I did try that but I still get the red underline.  The hide adornments removes the red asterisk and the little red arrow next to the text prompt, but not the red underline.

I created a new Text Box Prompt and set Required=No and Hide Adornments=Yes and the red line disappears.  So, I found that I'm seeing the red line because the parameter I'm using for the original Text Box Prompt is tied to one of the values in a stored procedure.  If I use a different parameter, I don't get the red line.  However, I need to be able to accept NULL or an empty string as the value for the stored procedure, and I don't like having the red line under the prompt box.  It makes the prompt look sloppy with the other graphics on the page.

Brian

[calson33]

I had a similar issue with prompts in SQL - In the end I had to make sure the prompt had a default value:

(#promptmany('parm1','string',sq('NotSelected'))#)

Hope that helps...

John

[bvacha]

Genius, John!  Since I don't need the multiple values, I used just the prompt macro in Framework Manager for the stored procedure value:

#prompt('parameterName', 'string', ' ')#

I couldn't get it to work with an empty string or without putting in a default string, so I'm using a single space as the default.  Not ideal, but very close to ideal.  This will work and I don't get the red underline anymore.

Thanks!
Brian