Input Mask

[jksdua]

Hey, I am trying to create a simple input mask but am unable to do it. I have a Number field of type Single to allow decimals. I would like to add a "%" sign at the end of this. Any help would be appreciated.

 

[llkhoutx]

Convert the single to a string and concantenate the "%", e.g.

cstr(me.YourControl) & "%" or

cstr(format(me.YourControl,FormatOfYourChoice) & "%"

 

[jwhite]

If the value entered is static and will never be used for calculations, then the previous response by (?) will suffice. HOWEVER, if your data is stored in a table field that is of type NUMBER, you will not be able to append the %, and you shouldn't... Keep the value in its native format (Number - Single) so it can be easily pulled to perform calculations when needed for forms/reports. If you need to show the value on a form/report with %, only then using the previous example by (?) for display purposes.