Why can't I select a number of form fields and change all their formatting at one time? For example, change a column of text fields to number fields. As it is, I have to change one field at a time. It's laborious, to put it mildly. I understand that it's probably easier to start from the beginning by defining the field as a number. However, when I use "Use current properties as new default", it still requires that I still have to go back to each one and change the decimal places.
Apparently, I wasn't clear. I apologize. I'm new at this. What I want to do is take a column of text fields and change ALL of them from none or text to the number format without having to do it one field at a time. I want to select the entire column and change ALL the fields from one format to another. When I try "Use current properties as new default" in an attempt to create the number fields with NO decimal places, it keeps defaulting to two decimal places which means that I still have to go back and change all of them one field at a time. It's the effectively same amount of effort that it takes to change the format and decimal places one at a time and I've gained nothing. I don't understand why something like this can't simply be done on an entire group of fields.
I read your explanation of the Java script and it's what I want. However, there's just one of me and it's not something that I can justify paying $60 to solve. I only have this problem a few times a year. Nonetheless, thanks for your help.
If you plan your work and work your plan, then life becomes easier. You did not do enough research on how to create forms.
There is also an option on the context menu, right mouse click, "Use Current Options as New Defaults" which will keep all the settings for the selected field when one selects the field to be used as the model for the defaults.
I've seen a few posts showing how to do this on a specified array where you have to type in each field. Is there a way to call the current selection as a variable instead of having to manually type them in?
What you can do is write a script to find and set the formatting.
Yes, field formatting is performed with a script. The predifined formats in the field property dialog are actually done with a script. So all you need to do is identify the script for the formating you want. Then use the setAction() function on the field object to set the script.
Do to do this you need two things, the names of the fields to be modified, and the script for the type of formatting. So please describe the what it is you want the fields to do. Are the data entry fields? or fields that just display a value (such as a calculated field)?
I don't understand why something like this can't simply be done on an entire group of fields.
It's often the abandonment of the "wrong" question that brings the right answer:
1. Delete all the text fields in the column, except the first one.
2. Set this field as required (Format : Number or whatever).
3. Give it a name that make sense.
4. Right-clic upon this field and choose : Create Multiple Copies.
It should take less than 30 seconds.
Thanks for providing a useful solution and not belittling the original question.
Will doing this just create clones of the first form field that then need to be renamed individually in order to show independent information, instead of all of them showing the same data that's in the original form field?
If so, then it's no less laborious than having to manually change the format on every form field.
You can, using a script, like this one I've developed: