Is there a function that would do the same as lpad (for example) in Access 97 ? I need to concatenate fields from a table and base the concatenation on the lenght of the field and not on the lenght of the text in the fields, so i would be able to put blank to fill the lack between the lenght of the text and the original lenght of the fields