using fixed length strings

Question

Hello. I'm trying to place four fields (coming in from a query) into fixed positions on a single fixed length string. I can tell Access VB to load the first field into the string, but I don't know how to put the second field star into the string starting in the 26th (as an example) character position, and the third field into the 32nd, and the fourth into the 39th. Assistance would be greatly appreciated. Maybe I'm even thinking of this as the wrong way- not using a fixed length string but an array of 50 single character elements, but again I'm not getting that to work either. I apologize if its answered before, but I can't seem to find the question in searching. This is not an output to a text file application, so its not an export thing.

Thanks, George

Answer 1

Assuming your form has 2 textboxes named s1 and s2 respectively and then you add another textbox with a control source of =GenFStr([s1],[s2])

it works just fine.  That said, you'd need to make the function smarter so you don't get #Error when missing values....

Answer 2

great, thanks. turns out one of my incoming fields had some nulls- hence the message. now if I could only get it to look more columner (if that's a word).

thanks again. George