none
Decoding SaveAsText's ConditionalFormat RRS feed

  • Question

  • Question: When SaveAsText-ing an MS Access form, conditional formats are saved in a binary format:

    Begin TextBox
        ...
        ConditionalFormat = Begin
            0x010000006c000000010000000100000000000000000000000500000001010000 ,
            0x00000000ffffff00000000000000000000000000000000000000000000000000 ,
            0x0000000000000000000000000000000000000000000000000000000000000000 ,
            0x540072007500650000000000
        End
        ...
        ConditionalFormat14 = Begin
            0x01000100000001000000000000000101000000000000ffffff00040000005400 ,
            0x720075006500000000000000000000000000000000000000000000
        End
    	...
    End

    Is the underlying C structure documented somewhere?

    (5400720075006500 is obviously the UTF-16-LE string "True", which I used for my test condition, and the parts before that are most likely offsets, lengths and formatting flags, but I'd rather avoid reverse-engineering the format manually.)

    Background (because "Why are you doing this?" will be the first question on your mind): We internally developed a tool to "diff" MS Access programs (there are some unclean legacy codebases from back before version control was used). The SaveAsText format works quite well for this purpose. We managed to decode most of the stuff that's relevant for us (PrtDevMode/PrtDevModeW is, for example, just the Windows API DEV_MODE structure in Ansi/Unicode encoding), but we're still trying to decide whether decoding conditional formats is worth the effort.

    Thanks, best regards
    Heinzi

    PS: Oh, and just to state the obvious: Yes, I am fully aware that SaveAsText/LoadFromText are undocumented, unsupported methods.

    • Edited by Heinzi.at Monday, July 31, 2017 8:03 AM
    Monday, July 31, 2017 7:53 AM

All replies

  • HI Heinzi.at,

    This forum(Access for Developers) is for development issues about table, query, form and access automation. Your issue is out of out scope.

    Best Regards,

    Terry

    Tuesday, August 1, 2017 8:49 AM
  • Hi Terry!

    Thanks for the information. On which MSDN forum would MS Access's SaveAsText/LoadFromText methods be on-topic?

    Thanks, best regards
    Heinzi

    Tuesday, August 1, 2017 12:21 PM
  • Hi Heinzi.at,

    Due to the limitation of the community support channel, I will suggest you contact the Microsoft professional support so that our engineers can work closely with you to troubleshoot this issue.

    If the support engineer determines that the issue is the result of a bug, the service request will be a no-charge case and you won't be charged. 

    Please visit the link below to see the various paid support options that are available to better meet your needs.  

    http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone 

    Thanks for your understanding.

    Best Regards,

    Terry



    Thursday, August 3, 2017 3:09 AM
  • Hi Terry!

    You might have misunderstood my question. I did not report a bug, nor do I need help fixing a problem.

    I am asking for the specification of a file format used by Microsoft Access. This could be answered either by someone from the MS Access development team (who has access to the specification) or by someone from the community (who has already reverse-engineered the format for their own purposes). Sorry, but the first-level support guys at "Microsoft Professional Support" won't be much help here (believe me, I've tried MPS a few times).

    Best regards
    Heinzi



    • Edited by Heinzi.at Thursday, August 3, 2017 7:38 AM
    Thursday, August 3, 2017 7:37 AM
  • Hi Heinzi.at,

    Your issue is really out of our scope. Bless someone from community will help with your issue. Good luck to you.

    Best Regards,

    Terry

    Friday, August 4, 2017 9:53 AM
  • Your issue is really out of our scope. Bless someone from community will help with your issue. Good luck to you.

    Hi Terry,

    I don't agree with you. The issue is out of scope for far the most of the users, but perhaps not all. The forum is a place where you could meet other Access users that do work beyond the borders of basic Access. Where else to go?

    Is all my work also out of scope while using no QueyDefs, no Reports, no Macros, but only Tables, Modules, and a handful of generalized forms? I agree I am not too much help for most of the questions, but nevertheless...

    Imb.

    Friday, August 4, 2017 10:44 AM
  • Hi Imb-hb,

    Thanks for pointing that. There is something unclear in my previous posts.

    For op's issue, it is really related with Access developing. But, to be honesty, I tried my effect to find information about SaveAsText binary format. There is so less information about this. 

    In my option, this is too depth in Access developing, and I am afraid it is not exposed by Microsoft.

    Thanks for your effects on Access developing forum. From supporting Access forum, I have learned a lot from you.

    If there is any wrong while my support, please let me know, I am kindly to accept your suggestions.

    Best Regards,

    Terry


    Monday, August 7, 2017 10:04 AM