i want to create this field:
Value1 & Repeat(' ',10-Len(Value1)) & Value2 & Repeat(' ',10-Len(Value1)) & Value3
But for some reason this is not working.
Is there another way to make this work? I also tried with Chr(9).. Same result
Thanks in advanced.
Actually I thought that your issue was that the character is not repeated as many times as is written in the function. In case of chr(127) it is repeated. But if you want to align the text to the right this would be a problem - the used font is not monospaced so each letter has different width.