Solved Input mask for a field in Percentage format

[zelarra821]

Good Morning.

I need to know how to put an input mask to a field that I have with Numeric data type, Double field size, and Percentage format.

I have tried to put 99.00 (in Spain we use the comma for decimals, and the point for thousands), but I divide the values of the field by one hundred in the following records, and I would not like to have to modify the formulas that I have in the source query, because they are quite complex.

Thank you!

 

[Pat Hartman]

You wouldn't use an input mask for this. You would define the format as percent at the table level. See the picture below.

 

[zelarra821]

Hi. "And the..." what? I don't understand. Thanks!

 

[Pat Hartman]

Sorry, the picture got in the way.

 

[zelarra821]

Ok, thanks a lot.

 

[Pat Hartman]

You're welcome.