Currency field allow only numbers - InfoPath Dev
in

InfoPath Dev

Currency field allow only numbers

Last post 03-14-2011 05:19 AM by ErnestoM. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-08-2011 10:36 AM

    Currency field allow only numbers

    What I have is the following situation. I have a field that is set to currency but I want to validate that it only accepts numbers and the "$" sign and "," for the 1000 place. But using the following code 
    not(xdUtil:Match(string(.), "\d*"))

    It does not accept that. Is there a better way to validate the field to only allow numbers or what can I add to this code to make it so that it would work for the currency field. Thank you.

  • 03-14-2011 05:19 AM In reply to

    Re: Currency field allow only numbers

    Is your field set to data type currency?

    http://office.microsoft.com/en-us/infopath-help/add-or-remove-a-currency-symbol-in-a-text-box-or-expression-box-HP010065296.aspx

    I don't believe any additional validation or code is necessary if the data type and format are set up.


    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.