Does anyone know if a text field can be dynamically changed in size to accommodate various amounts of text?
There is not an option to do this in FileMaker. Depending on how much time you want to spend on this, there are probably some ways to simulate this. Do you want the field to expand to the right or down? Some things to consider is if you want to expand down, what happens to everything below the expanding fields or if you want it to expand right, what happens to everything to the right of the field. Some other options to consider instead of expanding fields are using conditional formatting to change the font size, use scroll bars on fields, and use popovers to input data in expanded fields.
A field cannot be set to expand, but it can be set to shrink--and then only in specific contexts. The Sliding fields options that you set in the inspector can shrink a field and also a portal to just the size needed, but this change is not visible in Browse mode, it is used for Preview, print and save as PDF.
So in some cases, you can set a field to be very large in a layout dedicated to printing/PDFs and set it (and the layout objects below it) to slide up and resize the enclosing part.
Retrieving data ...