I have a table or query with a field called "LOG". This is a memo field containing a string of letter codes. ie "001012110 002351024 0026 1020" describing at 11 character intervals the list of materials logged at various depths. The log string length is variable and several approach 640 string length. I have a table of codes and material values ie 10 corresponding to SAND and 20 to GRVL etc. I tried using dlookup in a query on the LOG string, but the return string is too long. What I would like to do is design a macro or VB that returns a message box with the converted "LOG" codes to material values, in lengths of 40 characters per line, with a list popdown to view the log. I know what I need to do is create one long string of code, then parse it line by line. Any help is appreciated - I am faily new to access macros and VB.
Jim
Jim
