InfoPath Forms might serve you very well here. I wrote a short article on InfoPath forms here:
I will further comment on the scenario you have provided in a bold attempt to provide you guidance when I really don't have enough details on the reasoning behind your application requirements. You might consider replacing Access with MSDE since it appears that you have an enterprise solution, and Access may not scale to your needs at some point. MSDE gives you a reduced footprint of the SQL Server engine, at an affordable price. I'm not clear on where you will host the ASP.NET application, but assuming that you want to include this as part of the application deployment, I'm going to also assume that you can host an Intranet application in front of the Access database, and also (if appropriate) at the SQL Server location(s). If your goal is to populate forms with data, and have them print with a specific layout, you can definitely create Web services that generate data to display in these forms that can then be edited, resubmitted to the database through Web services, and/or printed from their local machine using InfoPath. The ASP.NET Intranet can supply a link for users to download forms.
Regarding the dynamic changes to font size and layout, I would recommend you reevaluate the purpose behind this requirement. Can the forms be redesigned so that all customers are happy with the same font and layout? If not, you would have to provide a different InfoPath form for each custom view. It is not possible to dynamically generate InfoPath forms (today) using the InfoPath SDK, however, you can modify existing InfoPath files such as the .xsf, .xsd, .xsl and .xml once the preliminary form has been created. The InfoPath SDK can be found here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ipsdk/html/ipsdkWelcomeToTheIPSDK.asp
For a comparison of InfoPath to other Microsoft solutions, see this article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_ip2003_ta/html/odc_ipinfopathdecisiontree.asp
For information on how to connect InfoPath forms to Microsoft Access Database see this and related links on MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ipsdk/html/ipsdkWelcomeToTheIPSDK.asp
Dig Deeper on Topics Archive
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.