Share
ReportI want an inputted number field to show in currency format.
The only way I can think of to do that is the let them put in the number, then make the field disappear and in its place show a label or button with the value altered to currency format in its place. In has to disappear only when the user inputs the whole number, so putting the formula in visible property does not work. I would make the label or button look like the input field so hopefully they wouldn't even know. Then, if they want to change the number, they click on that button and the text field shows again (basically changing the visibility of the button). But I cannot seem to change the visibility in the OnChange property of the field. Help!
Here is what I have: in the OnChange property for the input field that does not seem to work. I cannot get the input field to disappear.
If(IsBlank(DataCardValue14.Text),DataCardValue14.Visible = true,DataCardValue14.Visible = false)
All responses (
Answers (
549
