I would like your opinion about what is the best form for this scenario:
I am currently using pdf forms in my organisation that can be downloaded from a server, that are filled partially with some data from a mysql database. The forms are generated with pdftk and can be saved on pc and filled offline and then, when ppl get back into the office, they connect to the network and upload the filled data back to the mysql server. The problem is that the data they fill in is sometimes large and the form fields do not expand, instead the font automatically adjusts, but i would like for the fields to expand. Now Adobe livecycle could solve this problem with expanding fields but the problem is that, after the data is saved to the database and the form is downloaded again, the fields cannot keep the original size because the pdftk looses the format that was previosly saved(more pages, larger fields etc). Is there another way to generate dynamic offline forms that can keep their format each time they are downloaded?