Re: [MSAccessProfessionals] Binary Data in Forms and Reports

hi Norbert,

Thanks! AutoCorrect is a big culprit. It would be nice to have a list :)

1989 was before Access -- a� long time ago though ~ I made that note in 2010.

kind regards,
crystal

�

~ remote training and programming ~

connect to me, let's do it together

On 10/3/2021 11:47 AM, drnorbert@gmail.com wrote:

Hi Crystal,

Wonderful to hear from you.
You are correct, John suggested to me in 1989.
The issue with the reports and forms is that they tend to bloat.
I want to find out what creates the binary data in a form and report.
I delete all the binary data and the form size reduces to almost half.
Let me know if you are familiar with this issue.

Regards,

Norbert

On 10/3/2021 9:36 AM, crystal (strive4peace) via groups.io wrote:

hi Norbert,

thanks for sharing.

The text files created by SaveAsText are undocumented, and indeed interesting. Several years ago, John Viescas said to "Delete everthing between NameMap = Begin and the matching End statement and save the file." for cleaning up what AutoCorrect does.

kind regards,
crystal

Document Access Tables to Excel
https://www.youtube.com/watch?v=r6LRurruI44

On 10/3/2021 8:20 AM, drnorbert2002 wrote:

How and when the binary data is created in forms and reports?

�

I use the two undocumented functions. Application.SaveAsText and Application.LoadFromText �functions to export the form/report definitions, identify the binary data blocks and

I clean up the definition, and then import it again.

The Binary Data Blocks starts in �Parameter = Begin� and ends with �End�.

Also the I delete the �Checksum=� line. (should be on line 3)

The data blocks are in the following parameters.

• NameMap
• PrtMip
• PrtDevMode
• PrtDevNames
• PrtDevModeW
• PrtDevNamesW

Thanks,

�

Norbert

�

Norbert Foigelman, Ph.D.

NSF Services Corp.

Newport Beach, CA