I have a requirement to generate output records from a MS Access 2000 with TRUE EBCDIC hex values (low-values and high-values) so that an IBM mainframe can process them. I realize that low-values and high-values are tied more to COBOL output but I would have thought that someone else had gone down this road. I've looked all over and can't find a 'true' ascii to hex conversion routine supported by Access or VBA Script or VB, etc, etc, etc. If ANYONE could point me in the right direction I'd be forever grateful. After discussing this with some other developers, I don't even know if this is possible with Access.
The Hex() function is for displaying an ASCII value in Hex format - Not for actually creating/storing a Hex value. IOW, 'FF' is the hex value for 256 in ASCII. When you look at this value in an ASCII editor, it should be represented by '..' not 'FF' . COBOL programs generate these values in EBCIDIC format for submission to mainframes. This is what I need to do. Sorry if I confused you.