Automatic Padding in Text Box Prompt

[tbarne1]

All,

I have a prompt used to collect group numbers.   Our group numbers are 9 digits long (ex. 000000012).  In a ReportNet prompt, is it possible to have users only enter 2 digits and the other 7 digits be padded automatically?  I know you can do this when formatting report output (using ).  Is there anything similiar for prompts.

Thanks in advance.

[sir_jeroen]

Javascript.... that's all..

[mikegreen]

All,

I have a prompt used to collect group numbers.   Our group numbers are 9 digits long (ex. 000000012).  In a ReportNet prompt, is it possible to have users only enter 2 digits and the other 7 digits be padded automatically?  I know you can do this when formatting report output (using ).  Is there anything similiar for prompts.

Thanks in advance.

In your filter, make the prompt item get padded to 9 digits. So your filter would look something like this:

[Group Number] = RIGHT(('000000000' + ?Group Number Prompt?),9)

HTH,

Mike

[tbarne1]

Thanks Mike!  We are doing this in the filter to get the desired outcome in the report.  However the user wants a visual.  I am using the MultiSelect Text box.  When users enter 12 for example and then click insert they want to see 000000012 in the prompt.

Any ideas??

Thanks in advance.

[mikegreen]

Hmmmm... Multiselect? Doesnt the user select predefined values using the CTRL key?