I use Access 2000 (ADP) as a front end to a SQL Server 2000 database. I read about the FMS Total Access Memo product for adding rich text formatting to memo fields (or text fields in my case), and I immediately got excited about being able to offer this functionality to my users. I purchased the product and have been working with it for several months now. There are some quirks in sizing the ActiveX report controls, but code workarounds are available...
PROBLEM: If the data in the ActiveX control exceeds the 22-inch height limitation for a report section, the control overflows instead of displaying all of the data. For my particular application, this problem renders the control useless. If the data is displayed in a regular text control, ALL of the data is displayed, without regard to the 22-inch limitation. FMS has declared this to be a problem with the way Access handles ActiveX controls on reports. Anyone have any experience with this issue? Workarounds? Corrected with Access 2002? Other methods of implementing rich text formatting in a memo/text field?
Thanks...
PROBLEM: If the data in the ActiveX control exceeds the 22-inch height limitation for a report section, the control overflows instead of displaying all of the data. For my particular application, this problem renders the control useless. If the data is displayed in a regular text control, ALL of the data is displayed, without regard to the 22-inch limitation. FMS has declared this to be a problem with the way Access handles ActiveX controls on reports. Anyone have any experience with this issue? Workarounds? Corrected with Access 2002? Other methods of implementing rich text formatting in a memo/text field?
Thanks...
